Inactive User Report on all Systems

[urvashi]

Hi everyone, 

Reposting this from the JumpCloud Slack lounge. @lmcfadden has shared a whole youtube tutorial that he made that explains how you can pull a report of inactive users from all systems. He's also open to answering any questions that you may have so pop them in the comments below. 

https://www.youtube.com/watch?v=XMu7rm9Sq_U 

He also shared the list of search terms that he mentioned in the video:

{
  "service":[
    "systems"
  ],
  "start_time":"2023-06-21T23:37:40.391Z",
  "search_term":{
    "and":[
      {
        "or":[
          {
            "initiated_by.username":[
              "lmcfadden"
            ]
          },
          {
            "resource.username":[
              "lmcfadden"
            ]
          },
          {
            "username":[
              "lmcfadden"
            ]
          },
          {
            "and":[
              {
                "association.connection.from.name":[
                  "lmcfadden"
                ]
              },
              {
                "association.connection.from.type":"USER"
              }
            ]
          },
          {
            "and":[
              {
                "association.connection.to.name":[
                  "lmcfadden"
                ]
              },
              {
                "association.connection.to.type":"USER"
              }
            ]
          }
        ]
      },
      {
        "or":[
          {
            "system.displayName":[
              "ushq040"
            ]
          },
          {
            "and":[
              {
                "resource.displayName":[
                  "ushq040"
                ]
              },
              {
                "resource.type":"system"
              }
            ]
          },
          {
            "and":[
              {
                "association.connection.from.name":[
                  "ushq040"
                ]
              },
              {
                "association.connection.from.type":"SYSTEM"
              }
            ]
          },
          {
            "and":[
              {
                "association.connection.to.name":[
                  "ushq040"
                ]
              },
              {
                "association.connection.to.type":"SYSTEM"
              }
            ]
          }
        ]
      }
    ]
  },
  "timezone":"-0500",
  "interval_unit":"w",
  "interval_value":"1",
  "q":""
}

Thank you, Luke!

[lmcfadden]

Thanks for reposting!  The magic is happening thanks to the Directory Insights API.  We've built out a custom app for Make.com, but a similar approach could be used with any scripting / automation platform.  Our app just makes it easier to get started 😄