Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Sat Apr 20, 2024 5:11 am

View unanswered posts | View active topics


Board index » Support

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 12 posts ] 
  Print view Previous topic | Next topic 
Author Message
kevinratcliff
PostPosted: Wed Jul 21, 2010 7:41 pm 
Offline
Newbie

Joined: Mon Nov 28, 2005 11:17 am
Posts: 12
Greetings,

I'm running a recent SVN version of OA and love it. One thing I would like to be able to do is show a list of all PCs with an x64 operating system installed. I'm not seeing an obvious way to do this; am I missing something?

If it can't be done through the OA web interface, I can run a mysql query on the DB if someone would be kind enough to let me know what values to query for.

Thanks in advance for any help!

Kevin
Top
 Profile  
Reply with quote  
rsaavedra
PostPosted: Thu Jul 22, 2010 1:49 am 
Offline
Newbie

Joined: Fri May 28, 2010 4:49 am
Posts: 14
Interested in this as well.
Cheers,
Raul
Top
 Profile  
Reply with quote  
jpa
PostPosted: Fri Jul 23, 2010 9:41 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
[quote="kevinratcliff"]am I missing something?

No. I took a quick look and this information isn't collected. The last patch had a start at collecting the info but it is not saved to the OpenAudit database.

Top
 Profile  
Reply with quote  
kevinratcliff
PostPosted: Tue Jul 27, 2010 3:31 am 
Offline
Newbie

Joined: Mon Nov 28, 2005 11:17 am
Posts: 12
[quote="jpa"][quote="kevinratcliff"]am I missing something?

No. I took a quick look and this information isn't collected. The last patch had a start at collecting the info but it is not saved to the OpenAudit database.

Thanks for the reply! I guess this can be considered a feature request then.

At the risk of getting off-topic, can anyone recommend a tool that will collect this information from about 1000 domain-joined computers? I just need to know whether each computer is x86 or x64, nothing else.

Thanks!

Kevin

Top
 Profile  
Reply with quote  
jpa
PostPosted: Tue Jul 27, 2010 7:20 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
Quick stab at this. Didn't get to updating any views. This is just collection and database stuff. Pretty simple stuff. Worked for me when testing.

Need another post for the new install sql file.

Edit to replace the audit.vbs.txt file because I'm an idiot. Should work now.


Attachments:
audit.vbs.txt [230.52 KiB]
Downloaded 322 times
upgrade.php.txt [51.11 KiB]
Downloaded 325 times
admin_pc_add_2.php.txt [172.11 KiB]
Downloaded 312 times


Last edited by jpa on Tue Jul 27, 2010 8:10 am, edited 1 time in total.
Top
 Profile  
Reply with quote  
jpa
PostPosted: Tue Jul 27, 2010 7:21 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
Last file.


Attachments:
open_audit.sql.txt [69.81 KiB]
Downloaded 307 times
Top
 Profile  
Reply with quote  
ef
PostPosted: Tue Jul 27, 2010 9:41 pm 
Offline
Open-AudIT Fellow

Joined: Thu May 17, 2007 5:47 pm
Posts: 568
Location: Italy
Well done jpa, added to SVN rev. 1245.
I simply added to your files the updated index.php (to trigger the automatic DB upgrade) and some views.

_________________
Edoardo
Top
 Profile  
Reply with quote  
jpa
PostPosted: Wed Jul 28, 2010 2:16 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
Thank you and woops. I felt like I was missing something. Over time I have more files diverging from the base SVN.

Also as usual ef has done the real work and updated the views which I neglected. Thanks again.
Top
 Profile  
Reply with quote  
4077
PostPosted: Fri Jul 30, 2010 12:51 am 
Offline
Newbie

Joined: Tue Mar 16, 2010 10:44 pm
Posts: 25
Location: Germany
Is there a guide for doing a manual update?
Or a recommended way to do it properly?
I can't use SVN due to the corporate firewall. :-(

Unfortunately I'm not doing this every day under LAMP so I always need a guide/ cookbook for that kind of work. :D

Thanks in advance
4077
Top
 Profile  
Reply with quote  
jpa
PostPosted: Fri Jul 30, 2010 1:30 am 
Offline
Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259
[quote="4077"]Is there a guide for doing a manual update?
Don't know. But the basics are...

To download the latest OpenAudit version from SVN:
Go to http://open-audit.svn.sourceforge.net/v ... dit/trunk/
Scroll to the bottom of the page and select "Download GNU tarball"

Extract the files from the gzipped tarball:
tar xvzf open-audit-trunk.tar.gz

Copy everything or changed files to your web and scripts dir.

Log on to OpenAudit and you should get a notice at the top about an available database upgrade.

[url=http://www.urbandictionary.com/define.php?term=YMMV]YMMV[/url]

Top
 Profile  
Reply with quote  
4077
PostPosted: Fri Jul 30, 2010 6:32 pm 
Offline
Newbie

Joined: Tue Mar 16, 2010 10:44 pm
Posts: 25
Location: Germany
That's a tiny guide I can handle. :lol:
It worked.

Thanks.
4077
Top
 Profile  
Reply with quote  
kevinratcliff
PostPosted: Mon Aug 02, 2010 7:49 pm 
Offline
Newbie

Joined: Mon Nov 28, 2005 11:17 am
Posts: 12
Thanks jpa and ef, I updated from svn and had a chance to test this and it's working great! I appreciate your work on the OA project!

Kevin
Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 12 posts ] 

Board index » Support

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests

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:  
Powered by phpBB® Forum Software © phpBB Group