Client Management Suite

HI all,

I am designing a customized report which the removal date of software will be shown. The screenshot is showing the resource data history of a computer.

I am finding the date of action snapshot as like as the red box below. Do anyone know which table is storing the resource data history in Altiris database?

My Altiris version is 7.6 HF7 and the operating system is Windows Server 2012 R2.

The SQL server version is 12 sp3. 

Thanks.

If you will open SQL Management Studio and apply filter for "Tables" folder under your "Symantec_CMDB" database, specifying there InvHist, then you will see all available tables where different History data is stored.

For "AddRemoveProgram" history (shown in your screenshot) SQL table name is InvHist_AddRemoveProgram

Other details about history data for "Symantec_CMDB" database is here https://www.symantec.com/connect/forums/asset-recent-historychange-report

Hi Igor,

Sorry, I have missed one important information. I would like to show the specific removal date of software only e.g. I have uninstalled a software today. The report will only show this software and the removal date (i.e. today date)

I have found the InvHist_AddRemoveProgram table as well but it will show all of the inventory scanning date and installed date of softwares which a computer have.

For example, if Software A was uninstalled at 3/26/2017, software B was unisntalled at 3/28/2017 and software C was uninstall at 3/30/2017, all of their inventory scanning date will be today if I perform a inventory scanning and the uninstall value wll be all the same. ( p.s. Install date is actually which the software installed on the computer.)

Do you know which table will store the filter attributes as shown as below? This filter attribute should help to build my desired report.

I have search for tables InvHist_xxx / ResourceUpdateSummary / ResourceInventoryHistory  but no luck. Please advise. Thanks!!

Check the "Status" tab, it should give table names.

Hi Andy,

The Inv_AddRemoveProgram and Inv_InstalledSoftware have the installed date only but no other changed (e.g. remove/update) date.

The InvHist_xxx tables have installed date and inventory scanning date only, they don't have the other changes (e.g. remove/update) snapshot date.

What I need is the action change date (yellow highlight in screenshots 3 & 4) of the software resource, the action may be "added", "deleted" or "modified".

Do you have other clues? Thanks!!

Hi brainCamida!

"Added", "Modified" and "Deleted" parameters don't show exact date when appropriate software was uninstalled on managed client PC. It just shows when "NS.Hidden Purging Maintenance" task  has been executed on Notification Server and created these records in "InvHist_AddRemoveProgram" table, so same date(s) are shown on "History" tab in "Show Snapshot" drop-down menu of "Resource manager" page.

I've created a simple custom report to see what software is installed or uninstalled for selected managed client computer (No uninstall date is available there). Download attached .xml and import it via mouse right click menu on "Reports" folder in SMP Console and try it.

Regards,

IP.

Attachment(s)

Current installed_uninstalled software on client PC from ...xml   13 KB 1 version

Isn't the InventoryDate or CreatedDate the thing you're looking for?