Service Graph - SCCM - Robust Transform

[Community Alums]

Hi

Need help in parsing data and updating the asset tag

Example

If the first 3 Characters of the Computer Name does not start with 'ABC 'take the last 8 characters of the Computer name and update the Asset Tag column.

Can anyone suggest how is this done in the Robust transform Map

[maroon_byte]

Check with your SQL SME if they can help you to customize your SQL query used by Computer Identity data source. They probably would put IF in the SELECT statement to retrieve value accordingly.

Reference: https://stackoverflow.com/questions/13526592/using-if-else-in-sql-select-statement

Regards,

Sharad