
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2012 01:28 AM
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:
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!
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!
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2012 09:57 AM
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)
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2012 06:34 PM
Works perfect... thank you!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-13-2012 09:57 AM
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)
