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

Comments

Please log in to comment

Answers

0
Try something like this...

select distinct(M.ID) from MACHINE M
left join SAM_METER_DATA SMD on SMD.MACHINE_ID = M.ID
left join SAM_VIEW_ALL_SOFTWARE SVAS on SVAS.ID = SMD.TITLED_APPLICATION_ID
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.
Answered 01/05/2015 by: h2opolo25
Red Belt

  • 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.
    • You might also want to try select * instead of distinct(M.ID). I don't know what the label looks for.
      • 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.
  • 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.
Please log in to comment
Answer this question or Comment on this question for clarity