Notification

Icon
Error

Windows Activation - Is there a windows activation report

Posted: Wednesday, May 1, 2019 7:23:54 PM(UTC)
pfenton

pfenton

Member Original PosterPosts: 26
0
Like
Has anybody written a report that lists windows activation status?
endyk
#1endyk Member Posts: 24  
posted: 5/17/2019 10:39:03 AM(UTC)
Hello,

I found one that I slightly modified. Hope it helps.

Code:

Select Top 1000000
    Case
        When tblComputersystem.Domainrole > 1 Then
            'Server'
        Else
            Case
                When Coalesce(tblPortableBattery.AssetID, 0) = 0 Then
                    'Desktop'
                Else
                    'Laptop'
            End
    End                           As Type
  , tblOperatingsystem.Caption    As Operatingsystem
  , tblAssetCustom.Manufacturer   As Vendor
  , tsysAssetTypes1.AssetTypename As [Asset Type]
  , tblAssetCustom.Model
  , tblAssets.AssetUnique
  , tblAssetCustom.Serialnumber   As [Service Tag Number]
  , tblAssetCustom.Custom5        As AssetTag
  , tblAssetCustom.Contact        As [Allocated ID]
  , tblADusers.Displayname
  , tblState.Statename            As [Asset state]
  , tblAssetCustom.Custom3        As [PO Number]
  , tblAssetCustom.PurchaseDate
  , tblAssetCustom.Warrantydate   As [Warranty End Date]
  , tblAssetCustom.Custom2        As [Invoice number]  
  , tblAssets.Domain
  , tblAssetCustom.AssetID
  , tblAssets.Lastseen
From tblAssetCustom
    Inner Join tblAssets
        On tblAssetCustom.AssetID = tblAssets.AssetID
    Inner Join tblOperatingsystem
        On tblAssets.AssetID = tblOperatingsystem.AssetID
    Inner Join tsysAssetTypes    tsysAssetTypes1
        On tsysAssetTypes1.AssetType = tblAssets.Assettype
    Inner Join tblAssetGroupLink
        On tblAssets.AssetID = tblAssetGroupLink.AssetID
    Inner Join tblAssetGroups
        On tblAssetGroups.AssetGroupID = tblAssetGroupLink.AssetGroupID
    Inner Join tsysAssetTypes
        On tsysAssetTypes.AssetType = tblAssets.Assettype
    Left Join tblADusers
        On tblADusers.Username = tblAssets.Username
           And tblADusers.Userdomain = tblAssets.Userdomain
    Left Join tsysIPLocations
        On tblAssets.IPNumeric >= tsysIPLocations.StartIP
           And tblAssets.IPNumeric <= tsysIPLocations.EndIP
    Inner Join tblComputersystem
        On tblAssets.AssetID = tblComputersystem.AssetID
    Left Join tblPortableBattery
        On tblAssets.AssetID = tblPortableBattery.AssetID
    Inner Join tblState
        On tblAssetCustom.State = tblState.State
Where tsysAssetTypes1.AssetTypename = 'Windows'
      And tblAssetCustom.State = 1
Order By tblAssets.AssetName

Active Discussions

Lansweeper How do you scan your assets on your network?
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:14:18 AM(UTC)
Lansweeper How EXACTLY Does LS Count Assets?
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: Yesterday at 10:14:48 PM(UTC)
Lansweeper URL for Custom Reports
by  Joe Conger   Go to last post Go to first unread
Last post: Yesterday at 6:52:06 PM(UTC)
Lansweeper Add Document as File Link
by  mowo  
Go to last post Go to first unread
Last post: Yesterday at 2:00:25 PM(UTC)
Lansweeper Table View Filter
by  tgt   Go to last post Go to first unread
Last post: Yesterday at 8:30:44 AM(UTC)
Lansweeper How to scan assets on a different network
by  twpseaton  
Go to last post Go to first unread
Last post: 6/25/2019 10:04:36 PM(UTC)
Lansweeper Lansweeper warnings sent to an email
by  MilicaM   Go to last post Go to first unread
Last post: 6/25/2019 2:23:29 PM(UTC)
Lansweeper ShellRunAs action in Lansweeper
by  DavidL  
Go to last post Go to first unread
Last post: 6/25/2019 11:58:07 AM(UTC)