SQL report on hardware or software install/uninstall?

[M.C Chain]

Hello Everyone! I am looking to create a view/report containting informaiton on any software/hardware installation/uninstallation and the affected computer.

Going through the massive Altiris database I can locate tables with software installation/uninstallation calls however I can not find any timestamps or hardware changes.

Are there any tables that would contain this information?

 

edit : I did find the Inv_AddRemoveProgram table however it does not seem to fit my needs.

[Alex Hedley]

Inv_InstalledSoftware might be of use.

 

What fields do you need?

• Uninstall date?

[M.C Chain]

Hi Alex,

I found the information I require in terms of the software from the tables/views below.

What I require is the hardware installation and uninstallation date.

 

Tables/Views

vRM_Computer_Item

ResourceAssociation

vSoftwareProduct

Inv_InstalledSoftware

[Alex Hedley]

Notification of Installation or Removal of Software https://www.symantec.com/connect/articles/notification-installation-or-removal-software

[M.C Chain]

Unfortunatly I have already found the query for the software portion. I need the hardware install/uninstall portion.

[Alex Hedley]

InstallDate exists already.

Did you see the query in the Article

SELECT InvHist_AddRemoveProgram.DisplayName as [Product Name],
InvHist_AddRemoveProgram.DisplayVersion as 'Product Version',
vComputer.Name AS [Computer Name],
vComputer.[IP Address],
vComputer.Domain,
case when InstallFlag = 1 then 'Installed' else 'Uninstalled' end as Activity,
InventoryDate as [Inventory Date]
FROM InvHist_AddRemoveProgram INNER JOIN vComputer ON InvHist_AddRemoveProgram._ResourceGuid = vComputer.Guid
WHERE (InvHist_AddRemoveProgram.DisplayName LIKE '%NotePad%')

[Igor Perevozchikov]

Hi M.C Chain!

There is already available default report "Computers with Hardware Changes" from "Inventory Solution" product.

 

You can clone this default "Computers with Hardware Changes" report via mouse right click menu in Symantec Management Console, then via mouse right click menu on cloned report, click "Edit" and check all required info from its SQL Query there.

Pre-requisite to see such Hardware history data in this report, you should enable 'History' for following Data Classes of "Inventory Solution" product:

When checked "Physical Memory", "Processor" and "Storage" checkboxes and saved changes, in "Symantec_CMDB" database tables their names will be:

• InvHist_HW_Physical_Memory
• InvHist_HW_Storage
• InvHist_HW_Processor

Hope that this will be helpful.

Regards,

IP.

[M.C Chain]

Hi Alex,

Thank you for the responce however I already have the software portion. I am in need of the Hardware install/uninstall date time.

[M.C Chain]

Hello Igor,

Thank you very much for the information. This has helped a lot.

I should be able to construct the views and queries I require!