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:
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