Forum Discussion

teppotahkapaa's avatar
teppotahkapaa
Icon for Expert rankExpert
2 months ago

Finding vanished devices with GQL?

Is there a way to retrieve a list of vanished devices with GQL? According to all-mighty AI (CoPilot) there are couple of ways to do it, though none of those seems to work.

So the question is if the AI is hallucinating? Or is that possible?

device
device_management
  • ahmadsous's avatar
    ahmadsous
    2 months ago

    Hi Teppo,

    Thank you for your question! Currently, our GQL doesn’t support querying vanished devices directly. The AI tools like Copilot may have generated suggestions based on generic GQL capabilities, but in this case, they don’t align with our product's existing implementation.

    If accessing this via GQL would be helpful, I’d love to understand your specific use case to explore how we might support it in the future. Feel free to share more details or let me know if you have any questions!

    Thank You!

  • teppotahkapaa's avatar
    teppotahkapaa
    Icon for Expert rankExpert
    2 months ago

    Hi ahmadsous 

    this issue goes to one of my favorite areas. When syncing CMDB data into ITSM systems, in this case I am talking about ServiceNow. That beast, or IRE inside Snow, uses sys_object_source table to map other system devices to CIs. And that table in current mode is "grow only" -type, so there are no ootb methods to clean that table, always just adding rows there.

    So we are trying to build some logic that would retrieve devices from SL1 and the SL1-created data from that table and then use some high-end AI to find if we could clean some rows from there. Also our "service owners" want to get that data retrieved into some other processes also

    /teppo

  • ahmadsous's avatar
    ahmadsous
    Icon for Moderator rankModerator
    2 months ago

    Hi Teppo,

    Thank you for your question! Currently, our GQL doesn’t support querying vanished devices directly. The AI tools like Copilot may have generated suggestions based on generic GQL capabilities, but in this case, they don’t align with our product's existing implementation.

    If accessing this via GQL would be helpful, I’d love to understand your specific use case to explore how we might support it in the future. Feel free to share more details or let me know if you have any questions!

    Thank You!