Open-AudIT

What's on your network?
It is currently Wed Jan 17, 2018 9:31 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 11 posts ] 
Author Message
PostPosted: Tue Feb 10, 2015 2:07 pm 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
Hi

am I able to export the "Installed Software" section for all devices? Preferably into xls?

Thank you

R


Top
 Profile  
Reply with quote  
PostPosted: Tue Feb 10, 2015 3:07 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Main Page, click the Group "All Devices".
Click menu -> Installed Software.
Click the excel icon in the menu bar on the right.
Done :-)

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Tue Feb 10, 2015 3:24 pm 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
Can I have the report to be grouped per device?

R.


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 11, 2015 12:53 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
You would need a line per software package, per device.
In short, no.
That report will be thousands of lines long (at least).
What are you trying to accomplish?

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Wed Feb 11, 2015 2:15 pm 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
Mark wrote:
What are you trying to accomplish?


I was asked to do sw audit for computers in our office. I believe that I am supposed to deliver what I can see on the screen "Summary - for xxx computer" when I click "Software" -> "Installed".

I see nice table with columns like Package Name, Contact, Version, Publisher, Date Detected, Installed On, Installed By. I want such table for one computer(device) to be exported into csv.

Ideally all devices to be exported into csv with one more column - device name.

I hope it is clearer now.

Thank you

Radek


Top
 Profile  
Reply with quote  
PostPosted: Tue Feb 17, 2015 11:08 am 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
any idea if such export could be done?

R


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 19, 2015 8:46 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Yes this can be done, but you're going about it incorrectly. This is why there is no Query definition for this report.

You should be asking questions such as -

If this is for an external software license audit, does the vendor have any rights to see other vendors installed software? For example, if it's on behalf of Microsoft, does Microsoft have any right to know what other software is installed on your computers?

Does the audit care about all the Microsoft patches?

Does the audit care about 'free' or 'open source' installed software?

You should really be narrowing down your scope before you get to the actual reporting level.

I have attached the report you want, but when you run it, it will likely be 1,000's of rows. I recently saw something similar which was nearly 1,000,000 rows. Obviously this is not useful. The Query Definition is attached. Use at your own risk.


Attachments:
Installed-SoftwareALL.xml [3.38 KiB]
Downloaded 86 times

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.
Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 19, 2015 10:53 am 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
Mark wrote:
Yes this can be done, but you're going about it incorrectly. This is why there is no Query definition for this report.


I have attached the report you want, but when you run it, it will likely be 1,000's of rows. I recently saw something similar which was nearly 1,000,000 rows. Obviously this is not useful. The Query Definition is attached. Use at your own risk.


Hi Mark

that is (almost) exactly what I wanted. I need to supply such a list to our global IT department. I guess it might be for auditing or for some certification or so.

Your query is good. I just added two fields
- timestamp - is that a date of the last scan performed?
- software_installed_on - for this field I would like the value "0000-00-00 00:00:00" not to be included in the report. Would you know how to do that?

Thank you for your help.

R


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 19, 2015 10:56 am 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
One more thing ....

Why the google search link is not exported in xls? It's a great thing to have it there. If I do copy from a browser I got it there.

R


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 19, 2015 1:53 pm 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1933
Location: Brisbane, Australia
Those fields can all be added, but we're getting into custom work territory here.
This is what Opmantek is for - please see my signature.

_________________
Support and Development hours available from Opmantek.
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
PostPosted: Thu Feb 19, 2015 1:56 pm 
Offline
Newbie

Joined: Wed Jan 28, 2015 10:24 am
Posts: 21
ok, fair enough.

Thank you so much for your help.

R.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group