Client Management Suite

We are looking to really refine the software inventory report that comes pre-installed with 7.5 (Reports - Discovery and Inventory - Inventory - Cross-platform - Software/Applications - Software - Installed Software By Computer). The report does mostly what we'd be looking for; we can enter a computer name and the report pulls back all of the software installed in a format that we can export and use elsewhere, however it pulls back a lot of stuff we don't need. We'd like to exclude some software from the list such as MSXML or Security Update for .Net or IncompatibleKextConfigData, etc.. I imagine that we can enter the items to exclude in the query after we clone the report but aren't clear on where, exactly how (there would be a lot of NOT statements and wildcards) and if there's a better way. I'd love to write a report with includes but being an academic institution, we have hundreds of pieces of software and would never be able to get all of the includes, it'd be easier for us to exclude what we know we don't want.

Does the sw that you want to report on have an institution identifier within the registry, as that would make it easier for the report modification, as custom inv could be used to gather yhat info and populate a custom dataclass which would then be joined to the reports query?

It doesn't. Basically we replace comptuers on a 4-year cycle nad each year when we do it we need to generate informationa and reports on all of the software that is on the machine to be replaced so that we know what to install that might not be in the image so the software could be anything. The issue is that a software report for a Mac could have 1500 items in it but most of them are junk and for a Windows machine, all of the Security Updates are on the report, among other things, which is also not needed.

Hmmm. OK, is all required sw deployed via sw mgmt solution, as you could isolate the report based on sw that has a policy or task associated with it? Another possible method would be to create an organizational group that contains all sw that you dont want to report on, and then use that group as the exclude reference.

Oh, I wish it were that simple. Not all of the applications are deployed by SW management (I wish!). I think I might have gotten the report to work a little bit but again, very manual but I figured it would have to be based on the large number of "applications" that show up in the report. 

im cloning the report now to take a look.. but you can use the IN to not have as many OR statements... ill show ya in a bit..

 

ok it worked for me... 

I tested this by going to the bottom of the sql code and the line 2nd up is the Where statement.... that is for the All Software. I ran the report first and took 3 pieces of software off the top and added them as so...

 and sci.[Name] not IN('7-zip 9.20','acrobat.com 1.6.65 English','Adobe Acrobat Pro 9.0')

 

so my where statement is 

WHERE ('%Computer%' = '%' OR LOWER (comps.Name) LIKE LOWER ('%Computer%')) and sci.[Name] not IN('7-zip 9.20','acrobat.com 1.6.65 English','Adobe Acrobat Pro 9.0')

 

and this works. It is a PITA as the name needs to be exact so for your ones like the .net if you can just add Security Update for .Net then that would work. I know MS Patches each one shows with a KB number. then you need to do the 

Or sci.[Name] not like 'Windows Security Update%'

 

hope that helps some...

add this statment to get rid of 60% of the garbage 

and 
          prog.DisplayName  not like '%update%'and prog.DisplayName  not like '%help%'
          and prog.DisplayName  not like '%redist%' and prog.DisplayName  not like '%proof%'
          and prog.DisplayName  not like '%pack%'and prog.DisplayName  not like '%suppo%'
          and prog.DisplayName  not like '%viewer%'        and prog.DisplayName  not like '%MUI%'
            and prog.DisplayName not like '%hotfix%'            and prog.Publisher not like '%Altiris%'

 

prog being 

    FROM dbo.Inv_AeX_AC_Identification ac 
        INNER JOIN dbo.Inv_AddRemoveProgram prog
        ON ac._ResourceGuid = prog._ResourceGuid 

Thats good as long as you dont use TeamViewer. :-D

I use very little of the pre built reports as I like to control exactly what happens in my reports