Jump to content


  • 0
JKFischer

Report: General Computer Info based on SN

Question

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

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • 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.