Find certain departments using equipment. Change ^^ with department code.

Select
  ORG1.MACHINE.NAME,
  ORG1.USER.CUSTOM_2 As 'Dept', <--- Remember I use CUSTOM_2 for department mapping for ldap yours might be different.
  ORG1.ASSET_DATA_5.FIELD_10008 As 'Status',
  ORG1.USER.FULL_NAME,
  ORG1.USER.WORK_PHONE,
  ORG1.MACHINE.CS_MODEL,
  ORG1.MACHINE.IP,
  ORG1.MACHINE.LAST_SYNC,
  ORG1.MACHINE.NOTES,
  ORG1.MACHINE.OS_NAME
From
  ORG1.ASSET_DATA_5 Inner Join
  ORG1.MACHINE On ORG1.MACHINE.BIOS_SERIAL_NUMBER = ORG1.ASSET_DATA_5.FIELD_89
  Inner Join
  ORG1.USER On ORG1.USER.USER_NAME = ORG1.MACHINE.USER_NAME
Where
  ORG1.USER.CUSTOM_2 Like '%^^%' <--- Remember I use CUSTOM_2 for department mapping for ldap yours might be different.