Add Machines to Manual Label in bulk
Is there a good way to add about 400 machines to a manual label. These machines share nothing in common so I cannot use smart labels.
Community Chosen Answer
One way I cheated with the manual label is by doing the following. I was needing to have about 700 machines in a manual label. I lucked out by having a list of machines in csv.
I took my csv and ran this formula on the cells where the machine names were listed ="'"&B1&"',". Assuming B1 is the start of your machine names. This will add ' ', to every cell after you click and drag down your list. Then copy and paste that new row into the SQL query below.
I created a dummy smart label. I then modified it to include an IN command in the SQL.
select MACHINE.*, C.CLIENT_CONNECTED, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION O ON O.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION C ON C.KUID = MACHINE.KUID AND O.ORGANIZATION_ID = 1 where ( MACHINE.NAME IN ('COMPUTER1','COMPUTER2', 'COMPUTER3'))
This will still be considered a smart label so you can still create a manual label afterwards. It does beat checkmarking 500 boxes though.