/build/static/layout/Breadcrumb_cap_w.png

Create Smart Label Based on Metering Data

The Problem I'm trying to solve

We needed to update the SAP GUI application, I don't have that many machines under my SMA, nevertheless, sending a 320mb MI to 720 machines on a shared 100mbps WAN with an office with almost 400 people is kinda hard.

I ended up deploying normally (with a lot of baby sitting), but that gave me an idea.

SAP GUI is a critical application to a lot of users, but not everyone. And because I'm deploying it to everyone, I had to alert, ask the user to restart the machine, etc, to well... everyone, even those that don't even use it.

What if, I could meter SAP GUI usage and deploy first to my heavy users, with the alerts and all, and on a second wave deploy silently to the other machines?


How to Solve the problem

I ended up making a SQL query returning the machines based on the metering data, then is just as easy as creating a new label! Se the steps below:


Go to Home > Label Management > Smart Labels > Choose Action > Create New > Device Smart Label

Just leave the default search criteria, we won't be using it.

Give the new label a name and save

Now find and open that label in Home > Label Management > Smart Label

Click on Edit SQL and paste the following query:

SELECT MACHINE.NAME AS SYSTEM_NAME,
MACHINE.SYSTEM_DESCRIPTION,
MACHINE.IP,
MACHINE.MAC,
MACHINE.ID as TOPIC_ID,
MAX(SAM_METER_DATA.SECONDS_USED) AS "SECONDS USED",
MAX(SAM_METER_DATA.END) AS "LAST ACCESS"

FROM MACHINE

LEFT JOIN SAM_METER_DATA
ON MACHINE.ID = SAM_METER_DATA.MACHINE_ID

WHERE SAM_METER_DATA.TITLED_APPLICATION_ID = "APP20020"

GROUP BY TOPIC_ID
HAVING MAX(SAM_METER_DATA.SECONDS_USED) < 1000
OR MAX(SAM_METER_DATA.END) < now() - INTERVAL 10 DAY


Change the APP ID with the ID that you are metering

WHERE SAM_METER_DATA.TITLED_APPLICATION_ID = "APP20020"


You can get this ID by going to Inventory > Software Catalog. Find and open the Software information and look at the URL:

[...]sam_detail_titled.php?ID=APP20020&IS_MOBILE=0[...]


The filtering criteria is going to be up to you, I'm filtering for machines that have more than 1000 seconds used OR had the software opened in the last 10 days, just change the numbers, delete one or the other, change the OR to an AND, etc. Whatever fits your specific case better.

GROUP BY TOPIC_ID
HAVING MAX(SAM_METER_DATA.SECONDS_USED) < 1000
OR MAX(SAM_METER_DATA.END) < now() - INTERVAL 10 DAY


That's it! Now you can use that label to deploy or patch metered software by use!


Comments

  • regarding the shared line, you probably should check the replication share feature, which sets up a local share so not every machine needs to collect the same files from a remote SMA. See here: https://support.quest.com/kb/209402/ - Nico_K 2 years ago
    • Yea, I'm working on that, but it wouldn't have helped, almost everybody got sent to home office. It would overload the WAN either way. Is there a way that I can make web facing shares? That would really help things. - IgorAngelini 2 years ago
This post is locked

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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