SCCM Dell Driver Links in report

LAST UPDATED: 2010-04-12

These 2 reports will determine the link to the dell driver page for the systems based on their OS and Architecture.

Change Log

Version 1.2

• Redid the OS  detection code should be more accurate and more efficient now.
• Fixed the chassis type issue

Version 1.1

• Initial Release

Known Issues

• When the page loads the Info on the page can be incorrect however the table with the drivers IS correct Refresh the page to correct.
• If os isn’t supported for the system by dell one that is will be displayed.
• Assumes Chassis Types 23 & 17 are servers and all others are not.

For the Specific Machine report don’t forget to add the prompt variable. “Properties -> Edit SQL -> Prompts -> “New Variable”

• Name: “variable”
• Prompt Text: “Computer Name”
• Provide SQL Statement:

begin
 if (@__filterwildcard = '')
 SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0
 else
 SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS
 WHERE SYS.Netbios_Name0 like @__filterwildcard
 ORDER By SYS.Netbios_Name0
end

Files

• [Download not found]
• [Download not found]