Main Page, click the Group "All Devices".
Click menu -> Installed Software.
Click the excel icon in the menu bar on the right.
Done
| Open-AudIT https://www.open-audit.org/phpBB3/ |
|
| Can I export section 'software - installed'? https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6408 |
Page 1 of 1 |
| Author: | cimenta [ Tue Feb 10, 2015 2:07 pm ] |
| Post subject: | Can I export section 'software - installed'? |
Hi am I able to export the "Installed Software" section for all devices? Preferably into xls? Thank you R |
|
| Author: | Mark [ Tue Feb 10, 2015 3:07 pm ] |
| Post subject: | Re: Can I export section 'software - installed'? |
Main Page, click the Group "All Devices". Click menu -> Installed Software. Click the excel icon in the menu bar on the right. Done
|
|
| Author: | cimenta [ Tue Feb 10, 2015 3:24 pm ] |
| Post subject: | Re: Can I export section 'software - installed'? |
Can I have the report to be grouped per device? R. |
|
| Author: | Mark [ Wed Feb 11, 2015 12:53 pm ] |
| Post subject: | Re: Can I export section 'software - installed'? |
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? |
|
| Author: | cimenta [ Wed Feb 11, 2015 2:15 pm ] |
| Post subject: | Re: Can I export section 'software - installed'? |
[quote="Mark"] 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 |
|
| Author: | cimenta [ Tue Feb 17, 2015 11:08 am ] |
| Post subject: | Re: Can I export section 'software - installed'? |
any idea if such export could be done? R |
|
| Author: | Mark [ Thu Feb 19, 2015 8:46 am ] | ||
| Post subject: | Re: Can I export section 'software - installed'? | ||
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.
|
|||
| Author: | cimenta [ Thu Feb 19, 2015 10:53 am ] |
| Post subject: | Re: Can I export section 'software - installed'? |
[quote="Mark"]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 |
|
| Author: | cimenta [ Thu Feb 19, 2015 10:56 am ] |
| Post subject: | Re: Can I export section 'software - installed'? |
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 |
|
| Author: | Mark [ Thu Feb 19, 2015 1:53 pm ] |
| Post subject: | Re: Can I export section 'software - installed'? |
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. |
|
| Author: | cimenta [ Thu Feb 19, 2015 1:56 pm ] |
| Post subject: | Re: Can I export section 'software - installed'? |
ok, fair enough. Thank you so much for your help. R. |
|
| Page 1 of 1 | All times are UTC + 10 hours |
| Powered by phpBB® Forum Software © phpBB Group https://www.phpbb.com/ |
|
