I am trying to paste the code found on the Patch Tuesday post from December 2024 but I get an error and cannot locate how to resolve. Can someone kindly assist? "Error converting data type nvarchar to bigint"
I am trying to do something that should be straight forward, but I must be missing something.Under "Risk Insights - > Active Vulnerabilities" I am trying to filter the report to show only the ones in a particular branch office, but it is not an optio...
Hello everyone!I found a great report, that show me practically everything I want, but I need to add some more things to show like tblNtlog.Eventcode and tblNtlogMessage.Message/ I tried to add them myself, but I had no luck in it... Is it possible t...
Shows any Window system with drive over 80% full, excluding Backup & Recovery Drives Select Top (1000000) tsysOS.Image As icon,
tblDiskdrives.Caption As Drive,
Cast(Cast(((Cast(Cast(tblDiskdrives.Size As bigint) -
Cast(tblDiskdrives.Freespac...
Hello!I am trying to add a field to the patch tuesday audit for AD Group Membership, and not succeeding.Is there a way to add this field? We have servers in patching groups kept in AD Security Groups.I'd like to be able to filter or query the audit b...
I'm trying to find a way to use Lansweeper to create a complete point-in-time configuration record for an individual asset.If I open an asset in Lansweeper online, it provides a detailed inventory of hardware, software, versions, shares, and much mor...
I need to add state does not equal Closed or In Audit. Can anyone give me a leg up?Select Top 1000000 htblticket.date As CreationDate,htblticketstates.statename As State,htblticket.agentid,htblticket.ticketid,htblticket.subject,htblticket.fromuserid...
Running Lansweeper Classic v12 - I'm trying to modify the "Software: Changes in the last 7 days report" so that it only shows NEW installs. I see a few older posts but they didn't show how to filter in the SQL.I asked Copilot to update the code and ...
