• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Import from SCCM split between Laptop and Desktop
#1
We are looking to fine tune our inventory in Easy Vista to distinguish our pc catalog between laptops and desktops.  Currently everything is imported into the parent catalog of workstation.

The current definition query looks like this 


SELECT DISTINCT

'Computing/Workstations' as 'Type',
Model,
Manufacturer

FROM

E_ASSET_TEMP_SCCM1

Is there an easy way to execute this?
jvolltrauer, proud to be a member of EV CONNECT FORUM since Apr 2018.

#2
This best solution is to capture the chassis type in your sccm query then translate that to the ev equipment type. You'll have to explore how best to do this in your environment.

If you need professional services assistance let me know. FMX solutions is a team of EasyVista experts well qualified to assist with configurations such as this. 

Good luck!

Jack Reeder
Jack Reeder
FMX Solutions Inc.
Jack.Reeder@fmxsolutions.com

#3
The less elegant way to Jack's suggestion is to specify each type based off the Model using a CASE statement in the Integration, eg
CASE
WHEN MODEL LIKE 'ThinkPad X1 Carbon 3rd' THEN 'Computing/Laptop/Ultrabook'
ELSE 'Computing/Workstations' END as Type,

We do this as we have a number of specific types that are not based off the Chassis, but are more organisational groupings.
It does become a burden as this list must be maintained whenever a new model is added to SCCM.
Wayne Smith, Charles Darwin University, Australia
proud to be a member of EV CONNECT FORUM since Jun 2016.

#4
(05-22-2019, 01:14 AM)wsmith Wrote: The less elegant way to Jack's suggestion is to specify each type based off the Model using a CASE statement in the Integration, eg
CASE
WHEN MODEL LIKE 'ThinkPad X1 Carbon 3rd' THEN 'Computing/Laptop/Ultrabook'
ELSE 'Computing/Workstations' END as Type,

We do this as we have a number of specific types that are not based off the Chassis, but are more organisational groupings.
It does become a burden as this list must be maintained whenever a new model is added to SCCM.

Find in google : https://blogs.technet.microsoft.com/breb...s-in-sccm/
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.






Users browsing this thread: 1 Guest(s)