Notification

Icon
Error

Report for computers marked as custom state but scanned recently

Posted: Thursday, April 4, 2019 1:28:23 PM(UTC)
JacobH

JacobH

Member Original PosterPosts: 175
0
Like
I mark computers as a certain state that aren't meant to be online, such as STOCK, DECOMMISSIONED, RECYCLED, SOLD, etc... but, in the case of STOCK, they are provisioned and Lansweeper doesn't mark them as active, though it does scan them.

So, I've made a report that you can have email you, if a computer comes online that you aren't expecting (i.e. you marked it as X custom state)... and it's where stuff has been seen in the past 3 days... (you can modify that)


You take the below report and modify the
Code:
And tblAssetCustom.StateName in ('Stock','Decommissioned')
criteria to whatever state you're looking for.


Code:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tsysOS.OSname,
  tsysIPLocations.IPLocation,
  tblComputersystem.Lastchanged,
  tsysOS.Image As icon,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
    And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssets.Lastseen > GetDate() - 3
  And tblAssetCustom.Statename in ('Stock','Decommissioned')
Order By tblAssets.AssetName


Active Discussions

Lansweeper Edit Work Time Enhancements
by  pipapo   Go to last post Go to first unread
Last post: Yesterday at 3:41:25 PM(UTC)
Lansweeper software authorization based on "name" AND "version"
by  deejay3670  
Go to last post Go to first unread
Last post: Yesterday at 2:53:28 PM(UTC)
Lansweeper HP Warranty scan - broken for some products
by  JérômeS   Go to last post Go to first unread
Last post: Yesterday at 2:34:13 PM(UTC)
Lansweeper Helpdesk Report for unresolved tickets
by  Walter  
Go to last post Go to first unread
Last post: Yesterday at 2:08:39 PM(UTC)
Lansweeper Certificate status & end dates
by  Antoine EVRARD   Go to last post Go to first unread
Last post: Yesterday at 1:01:37 PM(UTC)
Lansweeper Assign switch port to location map
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 5:21:54 PM(UTC)
Lansweeper Email Link back to ticket
by  TruckDriverTurnedIT   Go to last post Go to first unread
Last post: 5/26/2020 5:20:08 PM(UTC)
Lansweeper LSAgent not Scanning or Reporting all Software
by  cycleheat  
Go to last post Go to first unread
Last post: 5/26/2020 4:15:05 PM(UTC)