/build/static/layout/Breadcrumb_cap_w.png

% 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 10 years ago

Answers (0)

Be the first to answer this question

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ