Open-AudIT https://www.open-audit.org/phpBB3/ |
|
Some additional queries I have created https://www.open-audit.org/phpBB3/viewtopic.php?f=5&t=1746 |
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 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 |
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 https://www.phpbb.com/ |