Reporting on Software not installed
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2012 05:28 AM
We are collecting the laptop/desktop information through the Help the Help Desk in the login script. Now, as part of a compliance check, we need to report on computer not running a certain piece of software.
e.g.:
Hostname Software
COM-0001 SoftwareA 1.2.3
COM-0003
COM-0004 SoftwareA 1.2.3
Looking at this report we would see which machine don't hold that mandatory software.
We found it quite easy to report on discovered machines, on machines running the software, but i can't find an easy way to have a single report listing the discovered machine together with the information around that specific software.
Anybody encounter the same kind of requirement?
- Labels:
-
Service Mapping
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2012 01:15 PM
Just add OR Product Name is Soft 2 OR Product Name is Soft 3 to the filter.
On second thought, that doesn't sound right... my filter insinuates that if it isn't Soft 1 (it is Soft 2) it should show up. Tinker with the filter a bit. The data is there, we just need to get a solid filter.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2012 01:48 PM
The thing is that we don't know in advance what other soft are installed, this is a real life case were on a single PC we have 100+ soft installed. So this is not an option to have to use all the other software.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-06-2012 02:40 PM
Understood, ignore my ramblings about adjusting the filter. The filter is good.
I'm still baffled by your data and your view. The filter works for me. See attached report. It has computers that have SOFT 2 and SOFT 3 and no software at all. And again my report definition to be clear.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2012 03:22 AM
Still not getting it working as expected. I re-created a test setup in one of the demo instance, see attached:
- DB_View -> the database view
- PC1 -> PC with SOFT1 and SOFT2 installed on it
- PC2 -> PC with SOFT2 and SOFT3 installed on it
- Report_result, where i have 3 entries related to PC1 and PC2 -> so, not really the requested report.
I'm still not getting on how this could work. This was done on demo15 (if not yet refreshed) if you want to check it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-11-2012 04:30 PM
I did not think of that scenario... Good call, this isn't going to work well for us... Now I am also stumped on the best way to get your solution without some nasty customizations or use of the ODBC driver and more advanced queries with a Business Intelligence tool like SQL Server or Crystal Reports.
