Jump to content


JKFischer

Established Members
  • Posts

    5
  • Joined

  • Last visited

Everything posted by JKFischer

  1. 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.
  2. JKFischer

    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.
  3. 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##
  4. 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.
  5. 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".
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.