→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dennisatsub
Engaged Sweeper
hi,


I'm looking to create a report that pulls the "caption" portion of the hardware scan under SCSI. I have some firmware updates that need to take place on P400 and P400i raid controllers and this would help me greatly.


thank you!

Dennis
2 REPLIES 2
dennisatsub
Engaged Sweeper
perfect!
just what I needed. thanks so much for the speedy assistance!
Hemoco
Lansweeper Alumni
Please use the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblScsicontroller.Availability,
tblScsicontroller.Caption, tblScsicontroller.DeviceID,
tblScsicontroller.DriverName, tblScsicontroller.Manufacturer,
tblScsicontroller.ProtocolSupported, tblScsicontroller.Lastchanged
From tblComputers Inner Join
tblScsicontroller On tblComputers.Computername =
tblScsicontroller.Computername
Order By tblComputers.ComputerUnique, tblScsicontroller.Caption

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.