How to find the Software uninstallation using SCCM DB

[Jameer]

Hi All,

 

I am new with SCCM and I need some database struture infromation.

 

I am doing service desk and SCCM integration, my need is I need to populate the SCCM data into third party tool for that I have written ETL job on SCCM views.

 

By using the below views I am able to populate the computer and software installed on a computer.

v_GS_COMPUTER_SYSTEM and v_GS_SoftwareProduct.

 

Now my requirement is by using the DB how can I identify if particular computer is updated by installing or uninstalling the software. so I can create the ETL job which will upload only updated or incremental data.

 

Regards

jameer

[Jameer]

Hi Experts,

 

By using v_GS_ADD_REMOVE_PROGRAMS I am able to identify the newly installed software delta date.

 

Can anybody help me to identify the uninstalled software delta deta

[Peter33]

How about using the corresponding histrory view.

[Jameer]

Hi Peter,

 

Thanks for your reply

 

I am not aware with corresponding history view it would be helpful if you share the view name.

[Peter33]

Hi Jameer,

 

 

 

history views are starting with v_HS_.

 

So you could use v_GS_INSTALLED_SOFTWARE and v_HS_INSTALLED_SOFTWARE for deltas. That's how the hardware histrory in the resource explorer is being computed.

[GarthMJ]

ARP data does not traditionally have history views in CM07 or CM12, due to the sheer volume of data that would exist in them. v_GS_ADD_REMOVE_PROGRAMS will only show you x86 software. Use v_ADD_REMOVE_PROGRAMS instead for bet both. The installed Software view doesn't list all software on a PC. So you will need to query all software for all PCs each time and create your own history.