Skip to content

Dell BIOS Version Report

Featured Replies

On 3/26/2012 at 1:28 PM, P@docIT said:

begin

if (@__filterwildcard = '')

SELECT DISTINCT CompSys.Model0 from v_GS_COMPUTER_SYSTEM as CompSys Order by CompSys.Model0

else

SELECT DISTINCT CompSys.Model0 from v_GS_COMPUTER_SYSTEM as CompSys

WHERE CompSys.Model0 like @__filterwildcard

Order by CompSys.Model0

end

 

So it seems whatever this particular portion was intending to do, is not needed. 

2 hours ago, xerxes2985 said:

So it seems whatever this particular portion was intending to do, is not needed. 

You would use this for your prompt queries. For SSRS, you would only need the "else" query with a few quick mods.

I see from your screenshot that you have to manually type each item. personally, I would extend this to:

  • Prompt for manufacturer name
  • Prompt for model name (use cascading prompt)
  • Prompt for BIOS version (use cascading prompts)
23 minutes ago, GarthMJ said:

You would use this for your prompt queries. For SSRS, you would only need the "else" query with a few quick mods.

I see from your screenshot that you have to manually type each item. personally, I would extend this to:

  • Prompt for manufacturer name
  • Prompt for model name (use cascading prompt)
  • Prompt for BIOS version (use cascading prompts)

GarthMJ,

Luckily (or not) we only have one manufacturer (Dell). It would be pretty cool to add two cascading prompts for the other options. This is honestly the first SQL report I've tried to build, so it is quite new to me.

But... if you would like to assist, that would be awesome. :)
 

Join the conversation

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

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.