/build/static/layout/Breadcrumb_cap_w.png

Software Deployment Question


Machine Smart Label Based on Usage

01/05/2015 1875 views
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


All 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.
 
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