IIRC I got these on “myitforum” but I can’t remember where abouts.
I have modified them a bit to restrict to just the machines I have (mainly a Dell shop) and to exclude VMs.
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:
if (@__filterwildcard = '')
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.Netbios_Name0 like @__filterwildcard
ORDER By SYS.Netbios_Name0
- [download id=”6″]
- [download id=”7″]