Machine Smart Label Based on Usage

I have software metering set up for MS Office 2010 and 2013, we have many more licences for 2010 than 2013 so I need to find Computers who do not use office and replace Office 2013 with 2010 since they are unlikely to notice. I know I can get the report from the metering but i would prefer to create a smart label with the info and automate the process.

0 Comments   [ + ] Show comments

Answers (1)

Posted by: h2opolo25 9 years ago
Red Belt
Try something like this...

select distinct(M.ID) from MACHINE M
where SVAS.NAME like "%AutoCAD%"  -- Enter software name you want to monitor
and SMD.SECONDS_USED > 3600 -- Enter a time in seconds to distinguish by amount used. Change operand for > or <

Not sure if this will work in a Smart Label since the SAM_VIEW_ALL_SOFTWARE is a view, not a table.

  • Nope, i don't think this is gonna work, ill check again in the morning but its still empty after half an hour. it seems like this would be the logical next step to software metering, i'm surprised this is not easier to do. - HISDTechGuy 9 years ago
    • You might also want to try select * instead of distinct(M.ID). I don't know what the label looks for. - h2opolo25 9 years ago
      • Tried both, no luck :(
        we have thousands of machines so running a report and going one by one is not an option, hopefully i can find an answer for this. - HISDTechGuy 9 years ago
  • What if you took the SQL from a report and tried to modify it to work with your smart label? The report "Software Installed but not Used Last 6 Months" uses the METER and METER_COUNTER tables to determine this. Here is the line that might be what you need. METER_COUNTER.WINDOW_BEGIN > DATE_SUB(NOW(),INTERVAL 6 MONTH). I haven't used any metering here so I'm too sure. - getElementById 9 years ago
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