SQL Server Editions and Licenses with Custom Inventory Revisited
Gathering meaningful information about SQL Editions and the server's licensing setup was vital to our corporation. Like many of you, we downloaded the script found on this site and proceeded to test it for implementation. We ran into a number of obstacles that prevented the script from running effectively, including issues regarding server authentication, cluster limitations and SQL version incompatibility.
One of our brilliant admins modified to script to work across our enterprise without revising any permissions or having to run it locally on the machine, so I cannot take the credit for this script. A million thanks to you Branden.
I have also included report I modified which will return the following: Server Name, Edition, License Type, License Count, Cluster validation, Status, Last Contact Date and Location.
Follow the same instructions from Sean Yarger's article, but use this script. This worked, flawlessly, in our environment. I hope you will experience the same successful results we have had. Enjoy.
| License: | AJSL By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License |
| Support: | User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab. |
Comments
Failed if the agent was installed on D: drive
Hi
I have changed the VBS to get the Altiris Agent installed parh.
I have changed the following:
line 22: Dim objLocator, objServices, objReg, Inparams, Outparams, objCtx, s, sInvDir
line 168: WScript.Quit '<----- Exit script completely
line 176+
' Determine if box is 64 bit or 32 so know where to dump NSI files ----------------------------------------------------------------------------------------------
If bitval = 32 then
fGetStringValue HKLM,"SOFTWARE\Altiris\Altiris Agent","InstallDir",sInvDir
Else
fGetStringValue HKLM,"SOFTWARE\Wow6432Node\Altiris\Altiris Agent","InstallDir",sInvDir
End If
AddLog "Installdir = " & Left(sInvDir,Len(sInvDir)-13) & "express\Inventory\", runLogFile, True, ForAppending
InventoryDir = Left(sInvDir,Len(sInvDir)-13) & "express\Inventory\" '<----- path to Inventory folder
If oFSO.FolderExists(InventoryDir) = True Then '<----- Make sure it has a Inventory folder to place NSI otherwise exit
'If Echo = True Then WScript.Echo "Inventory folder is " & InventoryDir
AddLog "Inventory folder is " & InventoryDir, runLogFile, True, ForAppending
Else
'If Echo = True Then WScript.Echo "<---------------- Inventory folder not found " & InventoryDir
AddLog "<---------------- Inventory folder not found " & InventoryDir, runLogFile, True, ForAppending
WScript.Quit '<----- Exit script completely
End If
'Determine if Cluster ---------------------------------------------------------------------------------------------
******************************************************************************************************************
i hope it will be usefull.
Kind Regds
Steen
Would you like to reply?
Login or Register to post your comment.