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

Comments

  • 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?
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity