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 Clients missing specific Office feature
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:28:26 AM(UTC)
Report Center Windows 10 compliance (color-coded)
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 1:15:07 AM(UTC)
Lansweeper User association report query
by  endyk   Go to last post Go to first unread
Last post: Yesterday at 9:47:25 PM(UTC)
Lansweeper Report for SSAS and SSIS
by  The Boss  
Go to last post Go to first unread
Last post: 6/25/2019 6:53:21 PM(UTC)
Lansweeper Firefox 67.0.3 zero-day vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: 6/25/2019 3:34:44 PM(UTC)
Lansweeper PO Box Query
by  kmoc  
Go to last post Go to first unread
Last post: 6/25/2019 11:16:28 AM(UTC)
Lansweeper Computer Age Chart Report
by  CyberCitizen   Go to last post Go to first unread
Last post: 6/25/2019 8:40:47 AM(UTC)
Lansweeper Dell SupportAssist CVE-2019-12280
by  Esben.D  
Go to last post Go to first unread
Last post: 6/24/2019 9:15:20 AM(UTC)