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)
Please log in to answer
Posted by:
h2opolo25
9 years ago
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.
Comments:
-
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
