Client Management Suite

I'm running 7.0, if it matters....

I don't see a default filter for laptops.  Can anyone maybe walk me through how to create a dynamic laptop filter?

I managed to hack one together.  I dunno how efficient it is though.  If anyone has a better idea, please, please share it

I prefer the more granular dynamic filter on model, just because some things get weird.  You may accidentally pick up netbooks or iPads or tablets or ThinClients using chassis.  I do computer model as we get new devices.  But we have a full inventory I can pull model from, and there's only 6 laptop models.

To see model names, build a Computer Report that includes [Logical Device].[Description] and [Logical Device].[Model] for fields, then set up the Filter Expression to only include results where [Logical Device].[Description] is EQUAL to AT/AT COMPATIBLE.  From there, you'll get a report of the model type of all your computer resources.

You can then build a filter based on this, where [Logical Device].[Model] EQUALS Latitude E5500, or perhaps you could be more flexible and say where Model contains 'Latitude' or 'Precision M' or 'Vostro.'

This isn't fully dynamic though, since it requires you to add computer model.  But it may offer benefits above the chassis model shared above.

Can you tell I'm a Dell customer?  Hope this helps you as you build your filter.

We're a Dell shop too, so your idea may be easier.  However, I got lost here:

"set up the Filter Expression to only include results where [Logical Device].[Description] is EQUAL to AT/AT COMPATIBLE"

It doesn't seem to save when I type in "AT/AT COMPATIBLE" and I have no idea where I would find it in the dropdown list.  Suggestions?

Give it plenty of time before each selection.  When you type AT/AT Compatible, it will try to select from a list.  Make sure you delete any auto-fill information.  Perhaps click back to EQUAL to see if that helps, then click Save Changes.

So no matter what I did, it would blank out the AT/AT field.  So I hit the button to convert it to a SQL query, and manually typed AT/AT Compatible in there.  That worked perfectly.  This is what I came up with.

SELECT DISTINCT
   [dca2_HW Logical Device].[Model]
FROM
   [vRM_Computer_Item] AS [vri1_Computer]
      LEFT OUTER JOIN [Inv_HW_Logical_Device] AS [dca2_HW Logical Device]
         ON ([vri1_Computer].[Guid] = [dca2_HW Logical Device].[_ResourceGuid])
WHERE
   (
      (
         ([dca2_HW Logical Device].[Description] = 'AT/AT Compatible')
      )
   )
 

edit: And this allowed me to show each model type only once.