
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2010 01:20 AM
Hi,
I just started poking with reports and for accounting purposes, I created one that gives me the following information:
Make, Model, Serial Number, Asset Tag, BIOS version, User and Computer Name.
It works pretty well for me but a specific model of computer (Dell M4300) shows up twice in my report. All the other ones are fine. I also noticed that they don't appear twice in the Computers view of Lansweeper.
Here is my query:
Thanks for your help!
I just started poking with reports and for accounting purposes, I created one that gives me the following information:
Make, Model, Serial Number, Asset Tag, BIOS version, User and Computer Name.
It works pretty well for me but a specific model of computer (Dell M4300) shows up twice in my report. All the other ones are fine. I also noticed that they don't appear twice in the Computers view of Lansweeper.
Here is my query:
Select Top 1000000 tblComputerSystemProduct.Vendor As Vendor, tblComputerSystemProduct.Name As Model, dbo.tblBIOS.SerialNumber, tblSystemEnclosure.SMBIOSAssetTag As [Asset Tag], dbo.tblBIOS.SMBIOSBIOSVersion As [BIOS Version], dbo.tblComputers.Computer, dbo.tblComputers.Username From dbo.tblComputers Inner Join dbo.tblBIOS On dbo.tblComputers.Computername = dbo.tblBIOS.Computername Inner Join tblSystemEnclosure On dbo.tblComputers.Computername = tblSystemEnclosure.Computername Inner Join tblComputerSystemProduct On dbo.tblComputers.Computername = tblComputerSystemProduct.Computername
Thanks for your help!
Labels:
- Labels:
-
Report Center
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2010 10:10 PM
Awesome!! Money is on the way 🙂

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2010 08:58 PM
I believe dockingstation is chassis '12'
You can use something like
"where tblSystemEnclosure.chassistype <> 12"
You can use something like
"where tblSystemEnclosure.chassistype <> 12"

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2010 08:12 PM
Thanks for the quick answer!! These computers have docking stations. Is there any way around?
Thanks!
Thanks!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-09-2010 08:01 AM
The systemenclosure also contains docking stations, I'm guessing this computer has a docking station. (and has 2 records in tblsystemenclosure)
