Use 'Installed Software' instead. Daniel Ratliff
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Haritwal, Dhiraj Sent: Wednesday, September 14, 2016 11:04 AM To: mssms@lists.myITforum.com Subject: [mssms] Find computers without specific software installed Hi, I am trying to create a collection (WQL) with computers which doesn't have specific software installed like any Antivirus & used SMS_R_System with SMS_G_System_ADD_REMOVE_PROGRAMS & getting desired results. While checking the same for another software, getting half data in SMS_G_System_ADD_REMOVE_PROGRAMS & half data in SMS_G_System_ADD_REMOVE_PROGRAMS_64 which is confusing Is it the correct behaviour? Which WQL table we should use to get software installation details? Does it mean, 32bit softwares will get stored in ADD_Remove_Programs & 64bit software in SMS_G_System_ADD_REMOVE_PROGRAMS_64 table? How can we check what are the table/fields (column) available in WQL. Was trying with wbemtest Appreciate any help. Regards, Dhiraj ________________________________ This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. - This mail is sent via Sony Asia Pacific Mail Gateway.. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.