logo

NJP

Overview of Software Spend Detection

Import · Aug 29, 2024 · video

[Music] good morning everyone myself daa Jo Das from product success team of service now and I'm a product success architect in today's session we will go to one of the interesting feature of Sam which is software spend so before we start this is our safe hour statement and uh what do we have in the agenda today so so what is software spend why do we use it what should be the considerations and what do we have as a feature and then we'll dive into a demo now what is software spend so it's basically a separate application that you can use for tracking analyzing and optimizing software spend based on the data that you loaded from the financial application of your organization primarily this application produces the picture more for SAS landscape but then you can also uh measure the spending of your on-prem softwares in case if you are managing it in some other financial application what is the primary benefit of using software spend well from a gap analysis perspective you can see what are all the softwares organization has spent money on and then what out of them which are the softwares that Mak sense to be managed in Sam same way you will have visibility to the enter spend on a text on the text tack what kind of software are there and uh what are their Footprints from audit perspective it definitely gives you the money that you have spent for buying those software and what are the specific areas of maybe optimizing the cost cost maybe because of D usages or maybe due to demand on cost savings on overall technology spending or to avoid layoffs in order to start with software spending the plug-in we need is uh this which is software spin detection it is a plugin separate than that of soft SRO and if you are subscribed to SRO you will need no extra cost for activate it this plugin has dependency on Sam as well as predictive intelligence because there is a machine learning component to it and hence a separate contract or order form the team will execute with the client in order to ensure the legalities of uh of the application because you know you since AI is involved some training has to happen outside certain data center those kind of cases will be agreed through the contractor order form now this application is not available for on premise client only for client which who are on service now cloud in nutshell this application basically works this way from your Ledger or checkbook you will get the spending in uh that you have uh you have already spent on purchasing software then you will load it into service now system which will then go through some normalization effort and some data massaging and then it will produce this report the Discover spend this is the report which will then give you your what kind of money has already been spent on which type of products now let's see a quick demo of this small application from my Washington instance so right now you are looking at my Washington instance so post the plugin is activated we just need to go go here and say soft spend and that is where this module will be activated or visible now we have overview overlapping software all imported transaction and normalized transaction import trans transaction all these modules here must say overlapping software we have a separate video coming up I'll concentrate on the rest of the modules on software spend import transaction module is where we need to load the financial information now this is basically through our normal data source and transformation map and the template is given here the and I have already downloaded it and let me open it for you this is uh the Excel the template you have the transaction date vendor name description General general ledger account amount type location cost center Department Source type detail external ID employee ID employee name employee email now I must say the location cost center Department this three is has got nothing to do with our already loaded tables these are import independent columns but the reason to keep it without uh reference or independent of our Base Class table which are available in the platform is we wanted the all the records available in location cost center Department in your other cost or financial application to be reflected as it is you can definitely do some customization to relate this uh data to the coresponding tables that are available in service now so now I have filled the template with uh sample values you could see I have used Oracle Dropbox and macafe as vendor so description is some random description I added some more data as for whatever will be there in the finance application that you guys will be referring to so with this data I am trying to simulate the situation where you have loaded your billing related information from your finance application and these are the fields needed for the transactions to be loaded into the system let's get back into the instance and uh upload this file and upload and you could see the system is now extracting the rows just refresh and it is completed so here it is so we could see this transactions or the rows are loaded here and Target records has been created so Target record is created on basically this table which is all imported transaction and software Sam spend transaction software spend transaction so let's filter it out and this three has been created now we could see for macafe uh new publisher product has been identified automatically for Dropbox only the publisher has been identified but for orx uh nothing has been identified and we'll see what are this these are basically the part which is communicated which is coming from the predictive intelligent engine and it auto identifies if whatever you are uploading is a software and if yes what are the publisher and product considering This Is My Demo environment so uh we the accuracy is quite lesser this obvious softwares like Oracle web logic server and macf should have been populated a publisher and product but then in case this happens what we need to do is we open the in the record and then manually we can identify or tag a publisher or product so in this case we will see it's a publisher Oracle and web logic uh server and we'll save it and you can see state has been changed to manually labeled that means we manually altered it now if you can see the Dropbox one it is labeled that means service now engine has been able to at least find the publisher and whether it's a software or not you can add product here but we will not do it for now because we it will cover my another use case I'll show you in a minute so we could see three type of transactions now one maafe which is not identified as a software at all and no publisher and product Dropbox identified as a software publisher also identified but not the product an oracle which has been identified as a software and and is uh and the product is also there but we have we have done it manually ideally in production instance this renowned softwares will be autop populated from our predictive intelligence engine so this is the job which the business rule has triggered and which has caused you to load the transaction in this tables and then trigger the transformation into Target table which is our Sam spend transaction and then this job is responsible for the auto labeling of the transactions based on our content data service now let's see how this data reflects the the dashboard so the dashboard can be accessed by click overview and you could see this data has been loaded all Publishers is this cost now you have all this indicators these indicators are loaded from performance analytics reports and as you could see this jobs PA jobs this one as well as as these two jobs do populate the PA indicators in this dashboard now we have the graph bar chart with proper distribution of that uh spend and let's see our product how it stands so we have loaded or orle and web logic server web logic server to be specific and this is the one that we have added which is so I just ran the job which is uh performance analytics job uh this one and uh now I could see on the web logic server which is loaded uh our record is loaded is now reflecting the appropriate graph so initially we are not seeing any graph or any uh chart here due as we did not ran that job which I just did on the back end and it came up now this server is listed as proper you know transaction but you could see there are some pointers which say unmanaged now what are these unmanaged so let me give you the example from Dropbox and we did loaded Dropbox where we were not able to identify the product and hence it will come up as unnormalized now unmanaged means we are not only able to identify the product but also there is no model software model in the system to manage the same so how do we address it so what we will do is let's open this record this one and let's put a product of Dropbox here say business and save it and let's go to the product model table and let's see we have any product of Dropbox which is product of publisher Dropbox with Dropbox business as the product we don't so let's create it business and simply create it go back here and run the jobs again and let's wait for it to complete okay the job is completed now so I'll go here refresh and you could see the Dropbox business is properly identified and it's no longer unmanaged now going back to the uh total publisher here the unmanaged product is basically all the product for which which a software model is not there same is the case for unmanaged publisher total detection detected spend is addition of total account plus total expense spend an account spend and expense spend are to identify a transaction unmanage spend is the spend generated out of unmanaged products and publisher now now the total spend do include unmanaged spend so which means this and this also include the unmanaged spend and total spend is a summation of total account payable spend plus expense spend to show you how the custom location and all works let's go back to our uh Dropbox example in Dropbox you could see the cost center and this is what while grouping it you could see the custom cost center that we have loaded our Dropbox product against same is the case for department and location the last transaction which is macafe you could see it is not even listed here and I guess you guys might have found out why because it was not Iden ified as a software and no publisher and product again you can mitigate it by manually leveling it or reaching to service now content team to Pro you know upgrade the content service so that our PI engine automatically corrects it now there is another important aspect of this solution which is content service the moment you activate the plug-in the cont service in software asset management will have this one activated software spin transaction if you switch it on these are the field that will get pushed to the TR Training Center where our machine learning model can train on new data so just to show you how the theory part of this so when the content service is off you load the data through the Excel then the then the data is in your spend table and this is where our predictive intelligence uh will work and will autoc classify uh the is software uh field the product field the publisher field from your data it will communicate the vendor descript ion the GL expense Etc predictive intelligence engine will get the feed from the content data service which is again uh the the data storage where we have our already biged publisher product uh model strange and uh that will then help you in Auto finalizing the publisher and product in the in customer instance now if the content service is switched on the this procedure will stay as it is but then from your instance our content data service team will get the feed so that we can normalize or take an action on your specific data once the data is available your data is available in this uh data store then the our content team will ensure what kind of interpretation has to be made with your data and how better your data sits in the publisher and product field of the spend table when we are enabling the content service these are the only Fields along with uh mostly this Fields along with whatever is mentioned here is transferred one thing is is for for sure that is not transferred is your financial amount or anything that identifies you as a client so thus we could see how this application software spend can help you in understanding the total cost or money transaction already spent across purchasing maintaining software ac across your organization to conclude in this session we have seen how software spend will help you in understanding how the finance or money is spent across all your software purchases across the organization the important scripts and uh jobs in place and how to import the financial information from uh the application to this instance and how content service can help help you in the process with this I have come to the end of this session I hope you have find this session useful we'll connect you guys again in another session thank you

View original source

https://www.youtube.com/watch?v=E3a12stb3dg