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 Thu Mar 28, 2024 7:53 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
Author Message
PostPosted: Tue Nov 21, 2006 10:30 pm 
Offline
Newbie

Joined: Tue Nov 21, 2006 9:57 pm
Posts: 5
In addition to the wealth of info that OpenAudit will pull out, I have created some additional queries to see more information that was relevant to our organisation.

Others may find these useful.....

Screen Resolutions

Simply gives a breakdown of the screen resolutions currently in use to aid our web developer, clicking on 1024 for example will list the pcs that run 1024x768

Location

I used one of the manual data fields to store the location ie sales, reception etc and then created a query to pull this out, clicking on any of the locations will list the pcs in that location

Staff/Client

Similar to the Location query I used another manual data field to store whether the pc was used by a staff member or by one of our clients

Systems with No Location

I then created another query that would list all of the pcs that I hadn't entered a location for



None of these were particularly difficult but gave some more data we can get at the touch of a button!

I also added them to the queries menu with a nice little icon!

I am happy to share any of the sql if anyone needs it


Bloater


Last edited by bloater on Tue Nov 21, 2006 10:33 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 21, 2006 10:32 pm 
Offline
Moderator
User avatar

Joined: Tue Jan 25, 2005 3:09 am
Posts: 2140
Location: Scotland
Please feel free to share your ideas, if we like them enough, who knows we might just include them in the code.


Top
 Profile  
 
 Post subject:
PostPosted: Sun Nov 26, 2006 12:58 am 
Offline
Newbie

Joined: Sat Sep 30, 2006 3:49 am
Posts: 7
Location: Worcester Public Library
It sound greate, could you post the code.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 

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