LabTech Support Forums

Account Locked Out in AD

This forum is for discussion of monitor related issues.

Moderator: jware.connectwise

Account Locked Out in AD

Postby sbarnes.realtime-it » Wed Jan 27, 2016 4:22 pm

Thought some of you might find this useful.

acct-locked.jpg
acct-locked.jpg (41.38 KiB) Viewed 3567 times



The cool part is the Identity Field which pulls the username and computer they are coming from and adds it to the ticket.
Code: Select all
CONCAT(LEFT(SUBSTRING_INDEX(eventlogs.message,'Account Name:',-1),INSTR(SUBSTRING_INDEX(eventlogs.message,'Account Name:',-1),'Additional')-5),' from ',SUBSTRING_INDEX(eventlogs.message,'Computer Name:',-1)) as FieldName
{ yes, i am THE MrRat }
sbarnes.realtime-it
Full Member
Full Member
 
Posts: 113
Joined: Tue Jan 25, 2011 9:36 am

Re: Account Locked Out in AD

Postby charlesa.infinitesys » Fri Jul 29, 2016 1:51 pm

Hello,

Sorry to dredge up an old post, but I tried to implement this, and it is not pulling back all of the information the database. I was wondering if you would be willing to provide some help with this.


Charles
charlesa.infinitesys
Newbie
Newbie
 
Posts: 34
Joined: Thu Oct 17, 2013 12:43 pm

Re: Account Locked Out in AD

Postby sbarnes.realtime-it » Mon Aug 01, 2016 12:28 pm

charlesa.infinitesys wrote: it is not pulling back all of the information the database


what is it doing?
what is missing?
{ yes, i am THE MrRat }
sbarnes.realtime-it
Full Member
Full Member
 
Posts: 113
Joined: Tue Jan 25, 2011 9:36 am

Re: Account Locked Out in AD

Postby charlesa.infinitesys » Mon Aug 01, 2016 2:06 pm

Hello,

it is seemingly pulling back only part of the information I can directly query out of the mysql database. for example, I created a test user and locked it out on our DC (the monitor is applied to that DC). I can see it locked in out the database using SQLyog, but the monitor wont pull it back. I'ved tired to reset the monitor and rebuild the query.
charlesa.infinitesys
Newbie
Newbie
 
Posts: 34
Joined: Thu Oct 17, 2013 12:43 pm


Return to Monitors

Who is online

Users browsing this forum: No registered users and 2 guests

cron