% 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!!!!
Be the first to answer this question