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.

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

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

Thanks Garth, For needful information. Regards Jameer

Hi Garth, Thanks for information. In v_GS_PROCESSOR view there is one column available as family0 and it contains the integer value like 2,12,179. I guess there is mapping between the integer value and processor familiy. Please help me to findout that mapping. Also in same view we have column ProcessorType0, it also contain the integer values. It would be helpful if I found the integer value and mapping. Regards Jameer Regards Jameer

Hi All, I need to generate the processor report with below parameters 1. Number of cores for per processor 2. Processor type 3. Processor Family I tried to find that parameter in view v_GS_PROCESSOR but view does not have information related to number of processor Core. Processor type is in numeric using that number I am not able to indentify the processor type and processor family. Regards Jameer