I have created a custom application script for grouping of machines based on a service, along with the needed mcs profile, and the attributes are published to those machines that have the roles but when running the following I am not seeing the systems attributes updated:
select * from CM_COMPUTER_SYSTEM cs join CM_COMPUTER_SYSTEM_ATTR a on a.cs_id=cs.cs_id where a.cs_attr_key like 'UserProp%.Roles';
Environment
Release: Component: UIMMCS
Resolution
Run your script from the command line on one of the targets that has the resource:
Note the carriage return after the output. There needs to be a carriage return on the end of the last line of your script so that it outputs as above. If your output looks like following it will not update the niscache files as it should: