hello this is a video on SCM software usage myself and my colleague Sean Walker are going to give a demo on running SCM software usage the agenda is what is software usage what is secm software usage we move we then move on to the demo and finish with summary so what is software usage it's it talks about who's using uh a software product when the software product was last used how many times the software product has been accessed and the total times the software product has been used these usage records are stored in the samp SW usage table so what is secm sofware usage it's an sgcm samp use a scheduled iner job that is installed along with the other outof the Box SGS CCM service graph connector scheduled import jobs when software as m is installed on your instance it Imports software usage data from Microsoft Configuration manager also know as SCCM on a monthly basis so now on to the demo myself and my colleague Shan Walker are going to give a demo of running this samp usage job sha is going to show you how to create the Reclamation rule needed for this job to run successfully I'm then going to walk you through how the offer usage job uses this recation rule as part of its execution and then this going to be followed by demo of actually running the samp usage job we're going to be going ahead and we are going to be bringing in some usage data from secm so we have an secm environment connected to this instance and we actually are metering some software um some software products so what we're going to do today is we're going to actually to bring back some of that usage data and show you how secm data gets brought in the first thing we're going to need to do is set up some Reclamation rules for that software so what what software are we metering in that environment Amry and we're Google we're um doing chrome chrome okay so yes so we have metering enabled for Google and I'm not going to talk you guys through the setup of a Reclamation rule because I've already done a video video on this so if you haven't watched that please make sure you watch the other video on how to create a Reclamation Rule and so we're just going to leave it very basic it's total use time we're going to say 1 hour save that there we go and we are going to um add the product now so we're going to add the product we're wanting to bring metering data in for and so make sure we get the right one Google Chrome no not that one we want this one and we're going to hit save and then if we take a look here right this is an important piece is that we've selected the product Chrome and service now knows that Chrome is tied to the executable uh chrome.exe and that's really important because seccm doesn't when you set it up for metering you don't meter based off of a product it's looking for a very specific executable um so if you pick the wrong one in your software product list here it could very well have the wrong executable that seccm is tracking the usage data for so what we're going to do now is we're going to go ahead or what actually should say what do we do next Amry how does secm bring that data in yeah thanks Sean and so for inm there's a a software usage scheduled import job that you run and um so if you go down to actually if you want to show first the data source um that that's associated with the software usage job you can show um like out of the box what the data source is or um from the last time you used it and we can see here that um Chrome is not in here in this SQL query what happens is that the software usage job it looks up the Reclamation rules table um to see what um recation rules you have to find and then based on that will dynamically update the SQL query to include it'll be including our new Chrome um product in this query so we can see here that Chrome is not existing here at the moment so once we start the job running um it'll query the table see that um Chrome has been added and then dly update this query to include Chrome and then it goes out to Microsoft Configuration manager or SCCM um to to to pull back the soft meeting data for Chrome and um okay great so yeah then let's leave this open and see what happens we'll see that actually change when we run the import job so I just open up the Oh I thought I opened it up in a different tab one second here let me get that back all right so now I fixed up my windows sorry about that so now we're going to find the usage job here if I could type and we can take a look at that so this is the we want to run right Amry that's right Sean yeah and just just to call out for the demo purposes this job runs monthly on the second day of the month and for the purpose of this demo we changed it to 30 to be today the 30th of May um but that out of the box that'll be equal to two as opposed to 30 just that yeah perfect all right so now we're going to hit execute now and run this jobs again you wouldn't normally do this execute now this is just so we can actually show you what happen so if I come back over to the the data source job we should see here that yeah the SQL statement has in fact been updated when that import scheduled job ran and let's take a look and see if we can find Chrome oh there it is right there so perfect Chrome has been dynamically added to this SQL query because we added a Reclamation rule for Chrome so now any luck there'll be usage data in our seccm and system that we are can pull we pulled back into Sam usage table so we're going to go over to the workspace again come down to license operations come down and find our software usage and we're going to take a look for Chrome so let's take a look for Chrome we should put contains scrum just in case because we don't know and there we go we now have usage information uh in our system coming in from secm and just to to show you guys that it is in fact data coming in from today we can just put our updated date on here so you guys can see when these records were updated um and there they are so the created you can see they're created by me today today is the 30th of May and we now have usage information coming in so now this can be used um by the um you can now compare against the Reclamation rules and it can create removal candidates so that's pretty much how software usage data comes into secm so thank you very much Amry for that quick overview of how those secm jobs work yeah you're welcome Sean all right we'll talk to you soon thank you perfect so just to summarize um what we reviewed was what after usages we also reviewed secm software usages and we demonstrated how to run the sgcm samp usage import job and lastly just to finish up with some more information um I'm including links to the service now documentation page on Microsoft SCM software usage and to ANM white paper I wrote uh which includes a section onm software usage