You are a key member of the Lansweeper Operations team that brings together years of joint experience to to deliver the strategic projects in an efficient and effective manner.

You will report to the Business Operations Manager in Belgium and lead virtual international project teams across the entire world.ĭo you want to have impact? Well, every project you'll be leading will help us further scale the company and ensure processes and systems are designed and improved to enable us to be the Technology Asset Intelligence leader. You will be running multiple strategic projects at once, driving them to success. To further support our growth, we are looking to enforce our team with an experienced Global Program Manager. We are focusing on leading cross-functional projects where many different teams and departments are involved as stakeholders to achieve common strategic goals and we need your help. I'll dabble and see what I can come up with.The Lansweeper Operations team is a new and growing multi-disciplinary team supporting and enabling the entire organization in running their business. 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 Select Top 1000000 tblLicenses.softwareName,Ĭount(tblSerialnumber.ProductKey) As , You are running SQL Compact instead of SQL Express, but I think you can get the report to run if you take out the var in nvarchar with the code above.

Can you view keys using lansweeper