Customers report the fastest implementation times, highest satisfaction levels and best overall service from Certero according to Gartner's Peer Insights. Unifying ITAM/SAM reduces costs and consolidates your asset information it allows automation, vastly superior insight and BI.Ĭertero provides exceptional support for modern solution architectures. This is part Certero's unified platform for technology management, which can manage IT assets holistically from desktop to datacenter, mobile, SaaS & Cloud. The result is an ELP in real-time and a solution that provides clarity across all IT hardware and software.Ĭertero handles the complex data 'heavy lifting' so that you can concentrate on optimizing & managing your IT value & cost. It combines live data from Certero's advanced inventory and discovery with intelligent software recognition and license reconciliation tools, removing the need for manual labor from the SAM process. I'll dabble and see what I can come up with.Certero for Enterprise Software Asset Management is the Certero product.

Of course this has to account for number of seats. I need to tweak this to run a query check all keys I listed as purchased, against the scan of all keys used, and only show the keys that are available/unused. Now I just have to tweak it a little for example when I ran it, it shows me I have say 16 office standard in use, but 1 purchased and the license key. That script works! Thank you for your help. Inner Join tblSerialnumber On tblSerialnumber.ProductKey =Ĭast(tblSublicensesOrders.Licensekey As nchar(300))

Inner Join tblSublicensesOrders On tblLicenses.LicenseidID = TblSublicensesOrders.Nrlicenses Purchased,Ĭast(tblSublicensesOrders.Licensekey As nchar(300)) As Scan mode highlights areas where you can type keyboard characters by pressing a keyboard shortcut, using a switch input device, or using a device that simulates a mouse click. Select Top 1000000 tblLicenses.softwareName,Ĭount(tblSerialnumber.ProductKey) As , Can you view keys using lansweeper install Use this option if you want the OSK to suggest words for you as you type so you don't need to type each complete word.