Some additional queries I have created
Page 1 of 1

Author:  bloater [ Tue Nov 21, 2006 10:30 pm ]
Post subject:  Some additional queries I have created

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


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


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


Author:  A_Hull [ Tue Nov 21, 2006 10:32 pm ]
Post subject: 

Please feel free to share your ideas, if we like them enough, who knows we might just include them in the code.

Author:  chuynh [ Sun Nov 26, 2006 12:58 am ]
Post subject: 

It sound greate, could you post the code.

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group