Symantec Management Platform (Notification Server)

I need to create a report on video drivers and their versions.  I see this table:

Inv_HW_Video_Controller_Windows

Which contains all relevant video driver names but it lacks their versions.  Is there another table that has the correct versions?

Maybe try Inv_SW_Device_Driver_Windows to get a version?  May have to do a join based on device id to get it right. 

Use Device Driver Windows, and specify as many fields as possible.  Here's an explanation I provided awhile ago for a custom filter:
https://www-secure.symantec.com/connect/forums/inventory-wireless-network-driver-versions

I ended up writing a custom inventory vbscript task and grab the driver name and driver version from the Win32_VideoController class.  I also excluded the DameWare Development Mirror Driver since we use that in our environment but it was not relevant for what I wanted to report on.

Here is the script below.  Just replace the data class in bold with your own data class.

'Following is a sample custom inventory sript gathering information about processor of a machine and posting data
'to NS using Altiris NSE Component
'===================================================================================================================
'      On Error Resume Next

'Create instance of Wbem service object and connect to namespace
strComputer = "."
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

'Fire WMI Query
Set objCIMObj = objWMIService.ExecQuery("Select * from Win32_VideoController WHERE Name<>'DameWare Development Mirror Driver'")

'===================================================================================================================

'Create instance of Altiris NSE component
dim nse
set nse = WScript.CreateObject ("Altiris.AeXNSEvent")

' Set the header data of the NSE
' Please don't modify this GUID
nse.To = "{1592B913-72F3-4C36-91D2-D4EDA21D2F96}"
nse.Priority = 1

'Create Inventory data block. Here assumption is that the data class with below guid is already configured on server
dim objDCInstance
set objDCInstance = nse.AddDataClass ("{E4EE1BFF-3158-45E9-951F-54B1130F2AFD}")

dim objDataClass
set objDataClass = nse.AddDataBlock (objDCInstance)

For each objInfo in objCIMObj

'Add a new row
dim objDataRow
set objDataRow = objDataClass.AddRow
'Set columns
objDataRow.SetField 0, objInfo.Name
objDataRow.SetField 1, objInfo.DriverVersion
Next

nse.SendQueued

       

hi jason can you please help on this

how to run this query

do we have to exclude the sentence written in single quote ..

and which data class exactly we have to write their....for processor...?i.e 1 is found in

settings>>Notification server>>Resource and data class settings>>data classes>>inventory>>hardware>>processor..

let me correct if i am wrong....

The above is not a query but rather a custom inventory vbscript.  You would run it on a target machine using a run script task.  You first must create a custom data class though with the two fields Name and DriverVersion.  The one you see in the area you indicated is a sample custom data class.

After you create them you can query the item table to get the GUID of the newly created data class to put in the script in bold above.  I hope this helps.

Once you create the dataclass and run the script you should be able to query the new table to get the video driver information that you need.  You could also capture more information other than the name of the driver and the driver version if necessary for your applications.

hey thanks for the reply..

will let u knw after trying it.

hi good evening

as per your suggestion i crated data class under

settings>>Notification server>>Resource and data class settings>>data classes>> testing data class>>

under this.

Run the query to get the GUID of the data class. Also run the VB scipt successfully.

but when i m going to query the new table i am not able to get any driver version information..

only i got the new column name which created in data class.

What did you name the fields?  Also what was your query?  At first I would just go with select * from <data class table name> to see if you have any data.

i have created only two fields namely.

name and Driver Version

my query was 

SELECT * From Inv_test_Editable_Data_Class

and result was no info.

Also i have attached the screenshot of the same.