9 Replies Latest reply on Oct 29, 2018 10:43 AM by Nikolay Karetnikov

unlink unused card's id in Blueprint 5.2

Nikolay Karetnikov May 15, 2018 10:07 AM

Hello!

May be someone who supports Blueprint product will find it helpful.

When an employee leaves the company his ActiveDirectory's account is disabled, the card is sometimes given to other person and if the new owner swipes it over a reader, then there is no way for automatic registration as the card is still hold for no longer active but still valid Blueprint account.

So, the idea is to run nightly a procedure to unlink or rather to move the card to fake account of type 0=Employee.

Attached is all the code.

1. openLDAP is used to get disabled accounts of the last 3 days

2. joined with all the accounts\cards view to get a new table containing cardIDs to unlink and fake accounts [postfix _disabled]

3. powershell to get UTF csv out of the SQL

Thanks!

source_for_disabled_csv.sql.zip 712 bytes
compose_source_for_unlink.ps1.zip 435 bytes
vAllThoseWithCards.sql.zip 373 bytes

Re: unlink unused card's id in Blueprint 5.2

tcampbell@pharos.com May 15, 2018 10:07 AM (in response to Nikolay Karetnikov)

Hello Nikolay,

I've worked on a similar request from another client during which we developed a small command line tool that can be used to disassociate any / all badges registered to a list of user IDs. Basically, you provide a single column text file containing the list of departed user IDs. The command line tool is then executed against that list. The process may be automated through use of Windows task scheduler and a basic batch command.

Is this something you'd be interested in seeing?

Regards,
Tim.
Like Show 0 Likes(0)

Actions
- Re: unlink unused card's id in Blueprint 5.2
  
  Nikolay Karetnikov May 15, 2018 10:11 AM (in response to tcampbell@pharos.com)
  
  I'll be interested
  
  Like Show 0 Likes(0)
  
  Actions
Re: unlink unused card's id in Blueprint 5.2

tcampbell@pharos.com May 15, 2018 2:01 PM (in response to Nikolay Karetnikov)

Hello Nikolay,

Below is a URL from which you may download a zip file containing the command line tool. The zip file also contains a readme that details its usage. Please be aware that this was developed and tested against Blueprint 5.2 Service Pack 3.

https://private.filesanywhere.com/pharos/fs/v.aspx?v=8a6e658660636ea89ca6

Best regards,
Tim.
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
- Re: unlink unused card's id in Blueprint 5.2
  
  Nikolay Karetnikov May 16, 2018 3:11 AM (in response to tcampbell@pharos.com)
  
  It helps. Pros of your way is that there's no need to create fake accounts and I wonder how did you do that.
  I'd only wish Pharos's support told me it earlier [attachment]
  Thank you, Tim!
  
  BP52 - How to unlink a Card identifier from a user.pdf 204.0 KB
  
  Like Show 0 Likes(0)
  
  Actions
- Re: unlink unused card's id in Blueprint 5.2
  
  Nikolay Karetnikov Oct 26, 2018 6:25 AM (in response to tcampbell@pharos.com)
  
  Hello!
  Would you please share the utility again?
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: unlink unused card's id in Blueprint 5.2
    
    Scott Olswold Oct 26, 2018 10:22 AM (in response to Nikolay Karetnikov)
    
    Nikolay,
    
    Here's a permanent download link. Thank you!
    
    https://private.filesanywhere.com/PHAROS/fs/v.aspx?v=8a70628e5ca1a8bdaca1
    
    Regards,
    Scott
    
    Like Show 0 Likes(0)
    
    Actions
    - Re: unlink unused card's id in Blueprint 5.2
      
      Nikolay Karetnikov Oct 29, 2018 2:52 AM (in response to Scott Olswold)
      
      Thank you!
      The utility unlinks all the cards from users in the csv file.
      Would you please tell if there's a way to supply the utility with cards' id to unlink?
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: unlink unused card's id in Blueprint 5.2
        
        tcampbell@pharos.com Oct 29, 2018 10:36 AM (in response to Nikolay Karetnikov)
        
        Hello Nikolay,
        
        You can 'deregister' badges using its card ID through use of Blueprint's built-in Identifier Translation Data import. You will create an import file that lists each card ID and assigns its owner as itself. An example import file would look like this:
        
        2, 123456, 2, 123456
        2, 234567, 2, 234567
        2, 345678, 2, 345678
        
        Where 123456, 234567, and 345678 are the card IDs that will be deregistered.
        
        For more information regarding this data import type, please refer to the Blueprint Configuration Guide.
        
        Best regards,
        Tim.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: unlink unused card's id in Blueprint 5.2
        
        Nikolay Karetnikov Oct 29, 2018 10:43 AM (in response to tcampbell@pharos.com)
        
        it works! )))
        Where have you been last Friday!? ) We had to unlink 900 of those )
        Thanks a lot!
        
        Like Show 0 Likes(0)
        
        Actions

Go to original post