MS Office License info

<?xml version="1.0" encoding="utf-8"?>
<ScExport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.kaseya.com/vsa/2008/12/Scripting">
  <Procedure name="MS Office License info" treePres="3" id="1191466008" folderId="216735612934798" treeFullPath="myProcedures - NetworkDepot.Kyle.Test 2018.In Progress">
    <Body description="Script Name: MS Office License info&#xA;Script Desc: Searches MS Office directories for ospp.vbs and runs it, which prints license and prints some of it to the procedure log. If you want a complete copy of the info, edit the script and add your email on line 2. Can report using $MSOL$&#xA;&#xA;Date: 07/12/2018&#xA;Company: VirtualAdministrator&#xA;Author: Kyle&#xA;&#xA;(c) Copyright 2018 Network Depot, LLC (Virtual Administrator) ALL RIGHTS RESERVED.   This script is the property of Network Depot, LLC (dba VirtualAdministrator), and use is restricted to active clients.  Do not re-distribute without written authorization.">
      <Statement description="If you want an email sent with information, then update your email address here" name="GetVariable" continueOnFail="false">
        <Parameter xsi:type="EnumParameter" name="VariableType" value="ConstantValue" />
        <Parameter xsi:type="StringParameter" name="SourceContent" value="youremail@here.com" />
        <Parameter xsi:type="StringParameter" name="VariableName" value="email" />
      </Statement>
      <Statement name="GetVariable" continueOnFail="false">
        <Parameter xsi:type="EnumParameter" name="VariableType" value="AgentTempDirectory" />
        <Parameter xsi:type="StringParameter" name="SourceContent" value="" />
        <Parameter xsi:type="StringParameter" name="VariableName" value="kworking" />
      </Statement>
      <If description="">
        <Condition name="TestFile">
          <Parameter xsi:type="StringParameter" name="Path" value="#kworking#\MSOL.txt" />
          <Parameter xsi:type="EnumParameter" name="Condition" value="Exists" />
          <Parameter xsi:type="StringParameter" name="Value" value="" />
        </Condition>
        <Then>
          <Statement name="DeleteFile" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Path" value="#kworking#\MSOL.txt" />
          </Statement>
        </Then>
      </If>
      <If description="">
        <Condition name="Windows 32 or 64 Bit Check">
          <Parameter xsi:type="EnumParameter" name="Condition" value="Exists" />
        </Condition>
        <Then>
          <Statement name="Execute Powershell Command (64-bit, Run As System)" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Parameter1" value="" />
            <Parameter xsi:type="StringParameter" name="Parameter2" value="Get-ChildItem \&quot;C:\Program Files\Microsoft Office\&quot; | Foreach-Object {If(Test-Path -Path \&quot;C:\Program Files\Microsoft Office\$_\ospp.vbs\&quot;) {cscript -nologo \&quot;C:\Program Files\Microsoft Office\$_\ospp.vbs\&quot; /dstatus | Out-File \&quot;#kworking#\MSOL.txt\&quot;}}" />
            <Parameter xsi:type="StringParameter" name="Parameter3" value="False" />
          </Statement>
          <Statement name="Execute Powershell Command (64-bit, Run As System)" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Parameter1" value="" />
            <Parameter xsi:type="StringParameter" name="Parameter2" value="Get-ChildItem \&quot;C:\Program Files (x86)\Microsoft Office\&quot; | Foreach-Object {If(Test-Path -Path \&quot;C:\Program Files (x86)\Microsoft Office\$_\ospp.vbs\&quot;) {cscript -nologo \&quot;C:\Program Files (x86)\Microsoft Office\$_\ospp.vbs\&quot; /dstatus | Out-File \&quot;#kworking#\MSOL.txt\&quot;}}" />
            <Parameter xsi:type="StringParameter" name="Parameter3" value="False" />
          </Statement>
        </Then>
        <Else>
          <Statement name="Execute Powershell Command (32-bit, Run As System)" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Parameter1" value="" />
            <Parameter xsi:type="StringParameter" name="Parameter2" value="Get-ChildItem \&quot;C:\Program Files\Microsoft Office\&quot; | Foreach-Object {If(Test-Path -Path \&quot;C:\Program Files\Microsoft Office\$_\ospp.vbs\&quot;) {cscript -nologo \&quot;C:\Program Files\Microsoft Office\$_\ospp.vbs\&quot; /dstatus | Out-File \&quot;#kworking#\MSOL.txt\&quot;}}" />
            <Parameter xsi:type="StringParameter" name="Parameter3" value="False" />
          </Statement>
        </Else>
      </If>
      <If description="">
        <Condition name="TestFile">
          <Parameter xsi:type="StringParameter" name="Path" value="#kworking#\MSOL.txt" />
          <Parameter xsi:type="EnumParameter" name="Condition" value="Exists" />
          <Parameter xsi:type="StringParameter" name="Value" value="" />
        </Condition>
        <Then>
          <Statement name="GetVariable" continueOnFail="false">
            <Parameter xsi:type="EnumParameter" name="VariableType" value="FileContent" />
            <Parameter xsi:type="StringParameter" name="SourceContent" value="#kworking#\MSOL.txt" />
            <Parameter xsi:type="StringParameter" name="VariableName" value="msol" />
          </Statement>
          <Statement name="GetFile" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="RemoteFileName" value="#kworking#\MSOL.txt" />
            <Parameter xsi:type="StringParameter" name="KServerFileName" value="MSOL.txt" />
            <Parameter xsi:type="EnumParameter" name="Action" value="OverwriteNoAlert" />
          </Statement>
          <Statement name="Execute Powershell" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Parameter1" value="" />
            <Parameter xsi:type="StringParameter" name="Parameter2" value="Select-String -Path '#kworking#\MSOL.txt' -Pattern 'LICENSE STATUS:\s*-+(.*?)-+' | Select-Object -First 1 | % {\&quot;$($_.matches.groups[1])\&quot;}" />
            <Parameter xsi:type="StringParameter" name="Parameter3" value="True" />
          </Statement>
          <Statement name="GetVariable" continueOnFail="false">
            <Parameter xsi:type="EnumParameter" name="VariableType" value="ConstantValue" />
            <Parameter xsi:type="StringParameter" name="SourceContent" value="#global:psresult#" />
            <Parameter xsi:type="StringParameter" name="VariableName" value="isLicensed" />
          </Statement>
          <Statement name="Execute Powershell" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Parameter1" value="" />
            <Parameter xsi:type="StringParameter" name="Parameter2" value="Select-String -Path '#kworking#\MSOL.txt' -Pattern 'LICENSE NAME:\s*(.*?),' | Select-Object -First 1 | % {\&quot;$($_.matches.groups[1])\&quot;}" />
            <Parameter xsi:type="StringParameter" name="Parameter3" value="True" />
          </Statement>
          <Statement name="GetVariable" continueOnFail="false">
            <Parameter xsi:type="EnumParameter" name="VariableType" value="ConstantValue" />
            <Parameter xsi:type="StringParameter" name="SourceContent" value="#global:psresult#" />
            <Parameter xsi:type="StringParameter" name="VariableName" value="LicenseName" />
          </Statement>
          <Statement name="Execute Powershell" continueOnFail="false">
            <Parameter xsi:type="StringParameter" name="Parameter1" value="" />
            <Parameter xsi:type="StringParameter" name="Parameter2" value="Select-String -Path '#kworking#\MSOL.txt' -Pattern 'REMAINING GRACE:\s*(\d*)\s*days?' | Select-Object -First 1 | % {\&quot;$($_.matches.groups[1])\&quot;}" />
            <Parameter xsi:type="StringParameter" name="Parameter3" value="True" />
          </Statement>
          <Statement name="GetVariable" continueOnFail="false">
            <Parameter xsi:type="EnumParameter" name="VariableType" value="ConstantValue" />
            <Parameter xsi:type="StringParameter" name="SourceContent" value="#global:psresult#" />
            <Parameter xsi:type="StringParameter" name="VariableName" value="Grace" />
          </Statement>
          <Statement description="Can enable these 3 lines for debug purposes" name="WriteScriptLogEntry" continueOnFail="false" osType="None">
            <Parameter xsi:type="StringParameter" name="Comment" value="isLicensed: #isLicensed#" />
          </Statement>
          <Statement name="WriteScriptLogEntry" continueOnFail="false" osType="None">
            <Parameter xsi:type="StringParameter" name="Comment" value="LicenseName: #LicenseName#" />
          </Statement>
          <Statement name="WriteScriptLogEntry" continueOnFail="false" osType="None">
            <Parameter xsi:type="StringParameter" name="Comment" value="Remaining grace: #Grace#" />
          </Statement>
          <If description="">
            <Condition name="CheckVariable">
              <Parameter xsi:type="StringParameter" name="VariableName" value="#isLicensed#" />
              <Parameter xsi:type="EnumParameter" name="Condition" value="Contains" />
              <Parameter xsi:type="StringParameter" name="Value" value="LICENSED" />
            </Condition>
            <Then>
              <Statement name="WriteScriptLogEntry" continueOnFail="false">
                <Parameter xsi:type="StringParameter" name="Comment" value="Office is LICENSED $MSOL$" />
              </Statement>
              <If description="">
                <Condition name="CheckVariable">
                  <Parameter xsi:type="StringParameter" name="VariableName" value="#Grace#" />
                  <Parameter xsi:type="EnumParameter" name="Condition" value="GreaterThan" />
                  <Parameter xsi:type="StringParameter" name="Value" value="0" />
                </Condition>
                <Then>
                  <Statement name="WriteScriptLogEntry" continueOnFail="false">
                    <Parameter xsi:type="StringParameter" name="Comment" value="#LicenseName# - #Grace# days remaining $MSOL$" />
                  </Statement>
                </Then>
                <Else>
                  <Statement name="WriteScriptLogEntry" continueOnFail="false">
                    <Parameter xsi:type="StringParameter" name="Comment" value="#LicenseName# - no license expiration reported $MSOL$" />
                  </Statement>
                </Else>
              </If>
            </Then>
            <Else>
              <Statement name="WriteScriptLogEntry" continueOnFail="false">
                <Parameter xsi:type="StringParameter" name="Comment" value="Office is NOT LICENSED $MSOL$" />
              </Statement>
              <If description="">
                <Condition name="CheckVariable">
                  <Parameter xsi:type="StringParameter" name="VariableName" value="#Grace#" />
                  <Parameter xsi:type="EnumParameter" name="Condition" value="GreaterThan" />
                  <Parameter xsi:type="StringParameter" name="Value" value="0" />
                </Condition>
                <Then>
                  <Statement name="WriteScriptLogEntry" continueOnFail="false">
                    <Parameter xsi:type="StringParameter" name="Comment" value="#LicenseName# - grace period has #Grace# days remaining $MSOL$" />
                  </Statement>
                </Then>
                <Else>
                  <Statement name="WriteScriptLogEntry" continueOnFail="false">
                    <Parameter xsi:type="StringParameter" name="Comment" value="#LicenseName# - licesne is past its grace period $MSOL$" />
                  </Statement>
                  <If description="">
                    <Condition name="CheckVariable">
                      <Parameter xsi:type="StringParameter" name="VariableName" value="#" />
                      <Parameter xsi:type="EnumParameter" name="Condition" value="Exists" />
                      <Parameter xsi:type="StringParameter" name="Value" value="" />
                    </Condition>
                  </If>
                </Else>
              </If>
            </Else>
          </If>
          <If description="">
            <Condition name="CheckVariable">
              <Parameter xsi:type="StringParameter" name="VariableName" value="#email#" />
              <Parameter xsi:type="EnumParameter" name="Condition" value="DoesNotContain" />
              <Parameter xsi:type="StringParameter" name="Value" value="Youremail" />
            </Condition>
            <Then>
              <Statement name="SendEmail" continueOnFail="false">
                <Parameter xsi:type="StringParameter" name="To" value="#email#" />
                <Parameter xsi:type="StringParameter" name="Subject" value="MS Office License info for #vAgentConfiguration.machName#" />
                <Parameter xsi:type="MultiLineStringParameter" name="Body" value="#msol#" />
              </Statement>
            </Then>
          </If>
        </Then>
        <Else>
          <If description="">
            <Condition name="CheckVariable">
              <Parameter xsi:type="StringParameter" name="VariableName" value="#email#" />
              <Parameter xsi:type="EnumParameter" name="Condition" value="DoesNotContain" />
              <Parameter xsi:type="StringParameter" name="Value" value="Youremail" />
            </Condition>
            <Then>
              <Statement name="SendEmail" continueOnFail="false">
                <Parameter xsi:type="StringParameter" name="To" value="#email#" />
                <Parameter xsi:type="StringParameter" name="Subject" value="MS Office License info for #vAgentConfiguration.agentGuid#" />
                <Parameter xsi:type="MultiLineStringParameter" name="Body" value="#kworking#\MSOL.txt was not found. This probably indicates there is no ospp.vbs for the version of office on the machine." />
              </Statement>
            </Then>
          </If>
        </Else>
      </If>
    </Body>
  </Procedure>
</ScExport>
MS Office License info

How to Download Scripts

Login Here

Search

Get In Touch!

Additional Resources

About Us
