Pauls Blog

Recently I needed to find out if a user was in an Active Directory Group. The group contained more than 5000 entries, so using Get-ADGroupMember wasn't useful (it timed out) The following command worked well for me... get-adgroup " GroupName " -Properties Member | Select-Object -ExpandProperty Member | get-aduser |  Where-Object {$_.SamAccountName -eq " username "} For small groups, and for full member lists it's as simple as  Get-ADGroupMember groupname   Getting the actual AD details can be performed with powershell with the following get-aduser -Filter 'GivenName -like " FirstName* " -and Surname -like " LastName* "' or, if you know the SamAccountName... get-aduser  SamAccountName To list the groups that an account belongs to  Get - ADPrincipalGroupMembership username | select name

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time / 1000 AS runTimeSecs, req.user_id, req.reads, s.login_name, s.database_id, t.name AS [database_name] FROM sys.dm_exec_requests req inner join sys.dm_exec_sessions s        on req.session_id = s.session_id  inner join sys.databases t        on s.database_id = t.database_id CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

CREATE FUNCTION [dbo].[fnStrRemoveNonNumeric](@strText VARCHAR(1000)) RETURNS VARCHAR(1000) AS BEGIN     WHILE PATINDEX('%[^0-9]%', @strText) > 0     BEGIN         SET @strText = STUFF(@strText, PATINDEX('%[^0-9]%', @strText), 1, '')     END     RETURN @strText END

List Available LVM Volume Groups pvs List what Logical Volumes exist inside the group lvdisplay vg1   (enter the VG listed from the VG column from pvs)  Mount normally, ie: mount /dev/vg1/lv1 /mnt/disk  However, if the block size is greater than 4KB, you'll need to use fuseext2, something like... fuseext2 -o ro -o sync_read /dev/vg1/lv1 /mnt/disk

I developed the following SSIS expression to convert a US date to an Australian date. (DT_DATE)(TOKEN(datestart,"/",3) + "-" + TOKEN(datestart,"/",1) + "-" + TOKEN(datestart,"/",2)) Uses SSIS's token function as opposed to substring's etc...  I've found token to be more reliable and better suited to this outcome.

Recently I received an error in Visual Studio 2015 like this.. TargetInvocationException was not handled An unhandled exception of type 'System.Reflection.TargetInvocationException' occurred in PresentationFramework.dll In addition, the main window stated thread.cs not found.   Because I made a few changes before running the code (it compiled fine) It took me a while to locate the problem, it linked back to a XAML control. I previously had the code... GetRogue_Button.Visibility = Visibility.Hidden; But, when the code ran, the Button itself was null.  The method I placed the hide code in was called through an TextChangedEventHandler (I also used an observable collection in my code).  The solution: if ( GetRogue_Button != null && GetRogue_Button.Visibility != Visibility.Hidden) { GetRogue_Button.Visibility = Visibility.Hidden; }

https://myanwyn.blogspot.com.au/2014/08/how-to-recover-seagate-central-data.html