Wireless Access

 View Only

  • 1.  Username stripping inside Filter Query

    Posted 10 days ago

    I need to strip the Authentication: Username which comes in the format 242k4j2kr-e23e2-23213abcd.wifi.blabla.net.

    I need it without wifi.blabla.net as that part is the GUID which i need to use in the filter query.

    is it possible to achieve this using Regex ?

    Thanks

    Amit Khanna



    -------------------------------------------


  • 2.  RE: Username stripping inside Filter Query

    Posted 10 days ago

    If that's a SQL query to the Endpoint database, you could use the Postgres query language to strip it out. Here is an example where I filter the Intune Device ID from a longer string; the same may work in your case in a similar way:

    select attributes->>'Intune User Principal Name' as "Intune User Principal Name",attributes->>'Intune Model' as "Intune Model",attributes->>'Intune Jail Broken' as "Intune Jail Broken",attributes->>'Intune Operating System' as "Intune Operating System",attributes->>'Intune Managed Device Owner Type' as "Intune Managed Device Owner Type",attributes->>'Intune Management Agent' as "Intune Management Agent",attributes->>'Intune Azure AD Registered' as "Intune Azure AD Registered",attributes->>'Intune Compliance State' as "Intune Compliance State",attributes->>'Intune Device Name' as "Intune Device Name",attributes->>'Intune Azure AD Device Id' as "Intune Azure AD Device Id" FROM tips_endpoints WHERE attributes->>'Intune ID' = split_part(regexp_replace('%{Certificate:Subject-AltName-URI}','^.*DeviceId:',''),',',1)

    Brief explanation of how this works:

    Be aware that this processing may add some additional load on your ClearPass nodes; if they are already fully loaded, you may need to expand capacity. If the nodes are barely loaded, it probably is no problem.



    ------------------------------
    Herman Robers
    ------------------------
    If you have urgent issues, always contact your HPE Aruba Networking partner, distributor, or Aruba TAC Support. Check https://www.arubanetworks.com/support-services/contact-support/ for how to contact HPE Aruba Networking TAC. Any opinions expressed here are solely my own and not necessarily that of Hewlett Packard Enterprise or HPE Aruba Networking.

    In case your problem is solved, please invest the time to post a follow-up with the information on how you solved it. Others can benefit from that.
    ------------------------------

    Original Message


Related Content