% used in 90 days MySql
I need to find the percentage used of my MS Office apps. I need to find the % used in the las t 90 days. Here is my sql statement so far...
select DISPLAY_NAME, MACHINE.NAME as ComputerName, SYSTEM_DESCRIPTION, IP, MAC, REPLACE(MACHINE.USER_LOGGED,'\\','\\\\') as USER_LOGGED, CS_DOMAIN from (SOFTWARE, MACHINE_SOFTWARE_JT, MACHINE) where MACHINE.ID = MACHINE_SOFTWARE_JT.MACHINE_ID and MACHINE_SOFTWARE_JT.SOFTWARE_ID = SOFTWARE.ID
and not IS_PATCH order by DISPLAY_NAME
Please to help!!!!
Matt
1 Comment
[ + ] Show comment
-
By percent used do you mean you are trying to track how many users launched MS Office apps in the last 90 days? Have you setup metering in order to track application usage? - chucksteel 11 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
