I want to display only device with an arrow icon. anyone can help me this SQL query. Thanks
You won't be able to query that in a direct way (e.g. it's not as simple as a field in the MACHINE table). That status is evaluated on the fly in our UI code based on the current ORG being displayed and the value of KBSYS.KUID_ORGANIZATION.ORGANIZATION_ID for the KUID of the device in question.
Here is an example of how you can do this via a System UI raw SQL report to display devices listed in ORG1 that have been moved to another ORG. Doing this across multiple ORGs would require more complex raw SQL:
SELECT M.ID, M.NAME, M.KUID, KO.ORGANIZATION_ID FROM ORG1.MACHINE M
join KBSYS.KUID_ORGANIZATION KO on (M.KUID=KO.KUID)
where KO.ORGANIZATION_ID != 1;