Open-AudIT

What's on your network?
It is currently Sun Jan 21, 2018 3:03 pm

All times are UTC + 10 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Thu Jan 09, 2014 8:31 pm 
Offline
Newbie

Joined: Thu Jan 09, 2014 6:36 pm
Posts: 1
Hi,

We currently use Open Audit to gather a list of software installed on our PCs. From that, we export the data to CSV and run a script which compares this with a CSV or allowed software, which spits out another CSV containing issues/offending software and also version mismatches.

I want to try and streamline this process as much as possible. Ideally, I would like to create a custom report which gathers the system/software data and compares this to allowed software list (which will be imported into SQL). If this cannot be done, I will just use the system/software data and modify our current script.

So after all that, my question is has someone done something similar to this? Or is there a report available that can give me something like this? I have had a look around and cannot find anything like this.

Thanks in advance.


Top
 Profile  
Reply with quote  
PostPosted: Tue Jan 21, 2014 2:25 am 
Offline
Newbie

Joined: Wed Aug 01, 2012 5:49 pm
Posts: 33
Location: NRW, Germany
Sure this is possible.
All you need is SQL-Query that does exactly what you want.
If you can get your Data through SQL, the rest is peace of cake.
Just edit your Query in your Open Audit Report and select the Results.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 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