danieldauschI need to do a report for agents installed in last 30 days. I can schedule one to run with a view with first check-in time > "20100301 12:00", but I'd have to modify it monthly to be accurate. That's not good enough for me. I could do alerts for new agents, but that is instant and not set to every 30 days like I need it. The other one is to monitor office keys installed (to see if someone uses a wrong key), but I think I have some macro work to do in Excel. Anyway, I enjoy seeing what you guys know. All these things are great resources for IT. Thank you.
<?xml version="1.0" encoding="utf-8"?> <ScriptExport 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="Validate Windows & Office License" treePres="3"> <Body description="This script validates Windows and Office licenses.
Run the &#34;License Validation&#34; report under Logs to see the license statuses.

You will need to place this once in your VSASharedFiles folder on your Kaseya Server
mgadiag.exe: http://go.microsoft.com/fwlink/?linkid=56062

If you require more detail about the results (e.g. &#34;Unsupported OS&#34 please see the following website or contact Microsoft:

http://www.microsoft.com/genuine/downloads/FAQ.aspx

Thanks to Barry Harriman at Linkware in Australia for the initial idea!

Benjamin Lavalley
Senior Sales Engineer, Kaseya
benjamin.lavalley@kaseya.com
"> <If description="This script validates Windows and Office licenses.
Run the &#34;License Validation&#34; report under Logs to see the license statuses.

You will need to place this once in your VSASharedFiles folder on your Kaseya Server
mgadiag.exe: http://go.microsoft.com/fwlink/?linkid=56062

If you require more detail about the results (e.g. &#34;Unsupported OS&#34 please see the following website or contact Microsoft:

http://www.microsoft.com/genuine/downloads/FAQ.aspx

Thanks to Barry Harriman at Linkware in Australia for the initial idea!

Benjamin Lavalley
Senior Sales Engineer, Kaseya
benjamin.lavalley@kaseya.com
"> <Condition name="True" /> <Then> <Statement name="GetURL" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="URL" value="http://go.microsoft.com/fwlink/?linkid=52012" /> <Parameter xsi:type="StringParameter" name="ResponseFileName" value="#vAgentConfiguration.agentTempDir#\mgadiag.exe" /> <Parameter xsi:type="BooleanParameter" name="WaitComplete" value="True" /> </Statement> <Statement name="ExecuteFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="Path" value="#vAgentConfiguration.agentTempDir#\mgadiag.exe" /> <Parameter xsi:type="StringParameter" name="Arguments" value="/f #vAgentConfiguration.agentTempDir#\licenseresults.txt" /> <Parameter xsi:type="EnumParameter" name="ExecuteAccount" value="System" /> <Parameter xsi:type="BooleanParameter" name="WaitComplete" value="True" /> </Statement> <Statement name="GetFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="RemoteFileName" value="#vAgentConfiguration.agentTempDir#\licenseresults.txt" /> <Parameter xsi:type="StringParameter" name="KServerFileName" value="..\Docs\Audit\licenseresults-0.txt" /> <Parameter xsi:type="EnumParameter" name="Action" value="OverwriteNoAlert" /> </Statement> <Statement name="GetURL" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="URL" value="http://files.kaseya.com/sftp/readlicense.vbs" /> <Parameter xsi:type="StringParameter" name="ResponseFileName" value="#vAgentConfiguration.agentTempDir#\readlicense.vbs" /> <Parameter xsi:type="BooleanParameter" name="WaitComplete" value="True" /> </Statement> <Statement name="ExecuteFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="Path" value="%windir%\system32\wscript.exe" /> <Parameter xsi:type="StringParameter" name="Arguments" value="&#34;#vAgentConfiguration.agentTempDir#\readlicense.vbs&#34; #vAgentConfiguration.agentTempDir#\licenseresults.txt" /> <Parameter xsi:type="EnumParameter" name="ExecuteAccount" value="System" /> <Parameter xsi:type="BooleanParameter" name="WaitComplete" value="True" /> </Statement> <Statement name="GetVariable" continueOnFail="true" osType="Windows"> <Parameter xsi:type="EnumParameter" name="VariableType" value="RegistryValue" /> <Parameter xsi:type="StringParameter" name="SourceContent" value="HKEY_LOCAL_MACHINE\SOFTWARE\Kaseya\Kaseya Agent\WindowsLicenseValid" /> <Parameter xsi:type="StringParameter" name="VariableName" value="windowsstatus" /> </Statement> <Statement name="GetVariable" continueOnFail="true" osType="Windows"> <Parameter xsi:type="EnumParameter" name="VariableType" value="RegistryValue" /> <Parameter xsi:type="StringParameter" name="SourceContent" value="HKEY_LOCAL_MACHINE\SOFTWARE\Kaseya\Kaseya Agent\WindowsLicenseType" /> <Parameter xsi:type="StringParameter" name="VariableName" value="licensetype" /> </Statement> <Statement name="GetVariable" continueOnFail="true" osType="Windows"> <Parameter xsi:type="EnumParameter" name="VariableType" value="RegistryValue" /> <Parameter xsi:type="StringParameter" name="SourceContent" value="HKEY_LOCAL_MACHINE\SOFTWARE\Kaseya\Kaseya Agent\OfficeLicenseValid" /> <Parameter xsi:type="StringParameter" name="VariableName" value="officestatus" /> </Statement> <Statement name="GetVariable" continueOnFail="true" osType="Windows"> <Parameter xsi:type="EnumParameter" name="VariableType" value="RegistryValue" /> <Parameter xsi:type="StringParameter" name="SourceContent" value="HKEY_LOCAL_MACHINE\SOFTWARE\Kaseya\Kaseya Agent\Officename" /> <Parameter xsi:type="StringParameter" name="VariableName" value="officename" /> </Statement> <Statement name="GetVariable" continueOnFail="true" osType="Windows"> <Parameter xsi:type="EnumParameter" name="VariableType" value="RegistryValue" /> <Parameter xsi:type="StringParameter" name="SourceContent" value="HKEY_LOCAL_MACHINE\SOFTWARE\Kaseya\Kaseya Agent\WindowsName" /> <Parameter xsi:type="StringParameter" name="VariableName" value="windowsName" /> </Statement> <Statement name="GetVariable" continueOnFail="true" osType="Windows"> <Parameter xsi:type="EnumParameter" name="VariableType" value="RegistryValue" /> <Parameter xsi:type="StringParameter" name="SourceContent" value="HKEY_LOCAL_MACHINE\SOFTWARE\Kaseya\Kaseya Agent\WindowsKey" /> <Parameter xsi:type="StringParameter" name="VariableName" value="windowskey" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="true" osType="Windows"> <Parameter xsi:type="StringParameter" name="Comment" value="Windows License Key Status: #windowsstatus#" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="true" osType="Windows"> <Parameter xsi:type="StringParameter" name="Comment" value="Windows License Key Type: #licensetype#" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="true" osType="Windows"> <Parameter xsi:type="StringParameter" name="Comment" value="Windows License Key: #windowskey#" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="true" osType="Windows"> <Parameter xsi:type="StringParameter" name="Comment" value="Windows License Key Version: #vMachine.OsType# #vMachine.OsInfo#" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="true" osType="Windows"> <Parameter xsi:type="StringParameter" name="Comment" value="Office License Key Status: #officestatus#" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="true" osType="Windows"> <Parameter xsi:type="StringParameter" name="Comment" value="Office License Key Version: #officename#" /> </Statement> <Statement name="GetFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="RemoteFileName" value="#vAgentConfiguration.agentTempDir#\licenseresults.txt" /> <Parameter xsi:type="StringParameter" name="KServerFileName" value="..\Docs\Audit\licenseresults-1.txt" /> <Parameter xsi:type="EnumParameter" name="Action" value="OverwriteNoAlert" /> </Statement> <Statement name="WriteScriptLogEntry" continueOnFail="false" osType="MacOS"> <Parameter xsi:type="StringParameter" name="Comment" value="Mac OS X license validation not supported." /> </Statement> <Statement name="DeleteFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="Path" value="#vAgentConfiguration.agentTempDir#\mgadiag.exe" /> </Statement> <Statement name="DeleteFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="Path" value="#vAgentConfiguration.agentTempDir#\readlicense.vbs" /> </Statement> <Statement name="DeleteFile" continueOnFail="false" osType="Windows"> <Parameter xsi:type="StringParameter" name="Path" value="#vAgentConfiguration.agentTempDir#\readlicense.vbs" /> </Statement> </Then> </If> </Body> </Procedure> </ScriptExport>
danieldauschVersion Number: 2008 (SP1) - 5.1.0.0
I know this is an old posting, but I am new to Kaseya and I would like to know how to create a report based on this information gathered from this script.