SCSI report

[dennisatsub]

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

[dennisatsub]

perfect!
just what I needed. thanks so much for the speedy assistance!

[Hemoco]

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.