Open-AudIT
https://www.open-audit.org/phpBB3/

Software versions overview like they was in OA1
https://www.open-audit.org/phpBB3/viewtopic.php?f=20&t=6675
Page 1 of 1

Author:  Gwahlers [ Wed Feb 21, 2018 11:43 pm ]
Post subject:  Software versions overview like they was in OA1

I remember in OA1 there were overwiews like those after i clicked on "Java":

CNT | Prog | Version | Date
| 3 | Java | 5.1.21 | 2010-01-01
| 5 | Java | 6.2.11 | 2011-03-05

If i click on "|5|"-Button OA lists every System with that Java Version.

I miss that function in OA2 or i have not found yet. The builtin Java or Acrobat overview is not the same as in OA1.
Is there any way to recreate that overview?
I tried summary with table software but i cant filter only Java.
I tried query with the following code
Code:
SELECT COUNT( software.system_id ) , software.name, software.version
FROM `software`
WHERE software.name LIKE '%java%'
GROUP BY software.name
, but there is the missing count-Button for further system details.

Author:  shanimal [ Thu Feb 22, 2018 5:35 am ]
Post subject:  Re: Software versions overview like they was in OA1

from open audit community 2 I click on: All Devices, Report --> Software --> Software

this brings a list of over 9,000 software titles and you can click on any of them and it will list the names of the systems that have that software version installed

It does have specific acrobat info too: All Devices, Report --> Software --> Acrobat

Author:  Gwahlers [ Thu Feb 22, 2018 5:38 pm ]
Post subject:  Re: Software versions overview like they was in OA1

Yes but there is no way to filter all these Windows Updates like 'KB%' or Language Packs of every Microsoft products... I wish my 1400 rowed software-report was only filled with 200 rows. Or is there any way to filter that table in the background?

Or for further updates it would be nice when there is an optional "LIKE '%string%'" - filter field in summary-configuration.

Author:  shanimal [ Fri Feb 23, 2018 4:59 am ]
Post subject:  Re: Software versions overview like they was in OA1

You can do that if you are handy with mysql, but I'm not so good with that stuff

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/