Take out the top 50 in that query, just threw it together quickly. Daniel Ratliff
From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Thursday, August 21, 2014 12:24 PM To: [email protected] Subject: RE: [mssms] SCCM Software Inventory issue I have never had much luck browsing files in Resource Explorer. I prefer SQL. We track our Air inventory with ARP data. select top 50 Netbios_Name0, sf.arpdisplayname0, sf.ProductVersion0 from v_r_system SYS inner join v_GS_INSTALLED_SOFTWARE SF ON sys.ResourceID = sf.ResourceID where ARPDisplayName0 ='Adobe Air' Daniel Ratliff From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of [email protected]<mailto:[email protected]> Sent: Thursday, August 21, 2014 12:10 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] SCCM Software Inventory issue Hi, Recently installed SCCM 2012. I have clients reporting and have performed Software Updates to both workstations and servers. I was recently asked to determine how many and what versions of Adobe Air we have installed in our environment. Found an article (http://helpx.adobe.com/air/kb/determine-version-air-runtime.html) that said to query a file called "Adobe AIR.dll". In Default Client Settings for Software Inventory, I have set the file types to inventory to *.exe and *.dll (there are a few others as well). When I check "Software - File Details" under Resource Explorer for a machine I know has the file "Adobe AIR.dll". I do not see the file listed as being inventoried. I also noticed that another Adobe Air file with a space in the file name did not inventory either. Do I have to set the file type to more than *.exe and *.dll? Thanks, Paul 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. 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.
