→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dallas4u
Engaged Sweeper
I have a report that I custom made to primarily show computer name, model, identifying number (Dell service tag), purchase date and warranty expiration. It shows a few other things for the heck of it. What I'm TRYING to figure out is how to also show if the computer is in an 'Active' state, or not disabled on the domain (or disabled as well... but if it just shows if it's active that is fine). Here is the current code for the report:
Select Top 1000000 tblComputers.Domain, tblComputers.Computer, tblComputers.Description, Web40OSName.OSname, tblComputerSystemProduct.Name As Model, tblComputerSystemProduct.IdentifyingNumber As [Identifying Number], tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As [Warranty Expiration] From tblCompCustom Inner Join tblComputers On tblCompCustom.Computername = tblComputers.Computername Inner Join tblComputerSystemProduct On tblComputers.Computername = tblComputerSystemProduct.Computername Inner Join web40ActiveComputers On web40ActiveComputers.Computername = tblComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Where tblCompCustom.PurchaseDate Is Not Null Or tblCompCustom.Warrantydate Is Not Null

Here is another forum post with someone asking a similar question: Non-Active Computer Report. The issue is, I just want to add to my current report a column showing if the computer is active or not. Every time I try to take bits of the one report and add it to my report and join things it errors out and freezes Lansweeper for a few minutes.

Any help would be awesome... thanks!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Could you try the report below.

Select Top 1000000 tblComputers.Domain, tblComputers.Computer,
tblComputers.Description, Web40OSName.OSname, tblComputerSystemProduct.Name As
Model, tblComputerSystemProduct.IdentifyingNumber As [Identifying Number],
tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As
[Warranty Expiration], web40allcompstates.Statename As State
From tblCompCustom Inner Join
tblComputers On tblCompCustom.Computername = tblComputers.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
web40allcompstates On web40allcompstates.Computername =
tblComputers.Computername
Where (tblCompCustom.PurchaseDate Is Not Null) Or
(tblCompCustom.Warrantydate Is Not Null)

View solution in original post

2 REPLIES 2
dallas4u
Engaged Sweeper
Works perfect... thank you!
Hemoco
Lansweeper Alumni
Could you try the report below.

Select Top 1000000 tblComputers.Domain, tblComputers.Computer,
tblComputers.Description, Web40OSName.OSname, tblComputerSystemProduct.Name As
Model, tblComputerSystemProduct.IdentifyingNumber As [Identifying Number],
tblCompCustom.PurchaseDate As [Purchase Date], tblCompCustom.Warrantydate As
[Warranty Expiration], web40allcompstates.Statename As State
From tblCompCustom Inner Join
tblComputers On tblCompCustom.Computername = tblComputers.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
web40allcompstates On web40allcompstates.Computername =
tblComputers.Computername
Where (tblCompCustom.PurchaseDate Is Not Null) Or
(tblCompCustom.Warrantydate Is Not Null)