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 Windows 7 EOL
by  Esben.D   Go to last post Go to first unread
Last post: Today at 12:22:43 PM(UTC)
Lansweeper Patch Tuesday report, last 3 months
by  Esben.D  
Go to last post Go to first unread
Last post: Today at 10:55:07 AM(UTC)
Lansweeper Thunderbird 68 Vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: Today at 8:41:29 AM(UTC)
Lansweeper Drive Encryption statuses
by  JacobH  
Go to last post Go to first unread
Last post: Yesterday at 5:41:10 PM(UTC)
Report Center Local admin group report based on domain role
by  JacobH   Go to last post Go to first unread
Last post: Yesterday at 5:24:13 PM(UTC)
Lansweeper Number of scanned IPs
by  wayneRex  
Go to last post Go to first unread
Last post: Yesterday at 10:21:01 AM(UTC)
Lansweeper Ticket Summary by Agent?
by  susan.starr   Go to last post Go to first unread
Last post: 9/17/2019 4:41:26 PM(UTC)
Report Center Virtual machines and their host
by  klaus  
Go to last post Go to first unread
Last post: 9/17/2019 8:44:57 AM(UTC)