[Report: General Computer Info based on SN]

Got a reply from another location and thought I would post it here.

 

MAIN SQL QUERY:

 

select distinct v_R_System.Netbios_Name0, v_R_System.User_Name0, v_RA_System_IPAddresses.IP_Addresses0, v_R_System.Operating_System_Name_and0, v_GS_COMPUTER_SYSTEM.Model0 from v_R_System inner join v_GS_PC_BIOS on v_GS_PC_BIOS.ResourceID = v_R_System.ResourceId inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceId inner join v_RA_System_IPAddresses on v_RA_System_IPAddresses.ResourceID = v_R_System.ResourceID where v_GS_PC_BIOS.SerialNumber0 = @SerialNumber

 

PROMPT

Name: SerialNumber

Text: Please Enter the Serial Number of the machine:

 

SQL STATEMENT

begin

if (@__filterwildcard = '')

SELECT DISTINCT SerialNumber0 FROM v_GS_PC_BIOS with (NOLOCK) ORDER BY SerialNumber0

else

SELECT DISTINCT SerialNumber0 FROM v_GS_PC_BIOS with (NOLOCK) WHERE

SerialNumber0 like @__filterwildcard ORDER BY SerialNumber0

end

 

Hope this helps someone.

[desktop shortcuts]

We do something similar, but we place the shortcuts in the "All Users\Desktop" folder and none of our users have the rights to delete them.

[Report: General Computer Info based on SN]

I have a querie that I would like to turn into a report, but I am having trouple changing the pop-up into a report prompt. Any help would be greatly appreciated. Here is the code used for the querie.

 

select distinct SMS_R_System.NetbiosName, SMS_R_System.LastLogonUserName, SMS_R_System.IPAddresses, SMS_R_System.OperatingSystemNameandVersion, SMS_G_System_COMPUTER_SYSTEM.Model from SMS_R_System inner join SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_PC_BIOS.SerialNumber = ##PRM:SMS_G_System_PC_BIOS.SerialNumber##

[Report to show general computer usage]

Yeah, I was afraid that would be the answer. I appreciate the reply to verify it and have sent the request and other infomration over to our server team (they handle SCOM) for them to look into. Again, thank you for the reply. It was a useful verification.

[Report to show general computer usage]

I've looked through all of the canned Asset Intelligence reports but can't find one that shows what I need. I'm looking for a way to show a computers overall usage. What I need in the report is the Computer Name, usage in minutes for the last month, and average usage per day in minutes.

 

Prompting for a collection would be ideal, since we are looking to verify the need for the amount of computers we are replacing. You know, do we need more or less. Heck, maybe just a new rule to use as opposed to the xxxx.exe rules already there.

 

Problemis, we don't want just turned on, but actually in use. We are a Medical Facility and our computers are all on 24/7.

 

ANY help would be greatly appreciated. Or even just the disappointing, but possibly true, news that I am asking for something that SCCM just "don't do".