Recent content by Herdrich

Thank you!!!!!!

How to I merge multiple rows of data from the same table with the same ID. I have tried group by by I get the following error Column 'cos_attribute.bunit' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. The running this query...

I was just looking for the parent groups so it worked perfectly :)

Nice! Looks to be working. Just have to fix up my inputs and outputs. Thanks :)

Hello All, I am trying to loop this until it hits the top level parent groups. Currently I get the users group then the group of those groups. I want to be able to go up until I hit the top group. I could probably nest a few more foreach statements but there has to be a cleaner way to do this...

Nice that works I knew it had something to do with -match because I only found references to [0-9] about -match and not like.

I tried SACCTX[0-9][0-9][0-9] and SACCTX\d{3} but it pulled no servers in my full code. Also found out today that I can run the commands I needed on all of the SACCTX* servers so I will just leave it as is. Thanks for the recommendations. I will still toy around with it to see if I can find a...

I will try the SACCTX[0-9][0-9][0-9] in the morning although I believe I have tried that already. I am trying to get things that are like SACCTX123 and NOT like SACCTXABC.

Hello all, Im trying to sort by servers named SACCTX001 - SACCTX999 but everything I have tried seems to not work. What I have currently brings up some extra servers that I do not need I have tried SACCTX[0-9], SACCTX### and SACCTX/n. Does anyone know what I should be using? $filter =...

Try out | Sort-Object $cert

I am working on a script that adds a local administrator to remote systems. This is what i have so far but on some of the systems the account might already exists so the first part changes the password for it the second two add an account and add it to the administrators group. Everything works...

Well guess i asked too soon figured it out CurrentDb.Execute "INSERT INTO Training (SSN, Task, DateCompleted, DateDue) SELECT SSN, '" & Me.Combo14 & "', Date(), Date() From PersonnelMain"

Last line of code is actually From PersonnelMain

Having a bit of trouble getting this to run i found this http://www.1keydata.com/sql/sqlinsert.html witch talks about what you gave me but i cant get it to run tried it the way you had it this way and without the currentdb.execute still no luck. CurrentDb.Execute INSERT INTO "Training" ("SSN"...

I have a database that keeps track of employee training completion and due dates and im trying to figure out how to append a new training record to everyone’s record in the database. what I have now is if a new user is created a template is put into their record with all of the required...