Skip to main content

Posts

Some find commands - useful for copying iCloud Photos to another service.

I've found these commands really helpful when navigating an iCloud Photo library on a Mac. The native Photos Application on MacOS prohibits a lot of bulk file activity.  These commands should be run from Terminal. Before starting, it's best to place yourself in the following directory "/Users/**your username**/Pictures/Photos Library.photoslibrary" This command is best executed from the "Masters" directory  find . -iname  *.cr2  -exec ls -lh {} \; It finds all CR2 files and reports the file sizes   You could change the ls to a copy, say to copy the image to another folder, like another cloud drive.  Find all file types outside a defined list, and filter those only in the Masters directory find . -iname *.* | grep Masters | grep -v -i -E '\.jpg|\.jpeg|\.heic|\.png|\.cr2|\.gif|\.mp4'  Find all file types IN a defined list, and filter those only in the Masters directory find . -iname *.* | grep M...
Post a Comment
Read more

Get Results of Stored Procedure and insert to temp table

I needed to get the storage results recently of a bunch of SQL tables.   Here's how I did it. 1) Create a temporary Table CREATE TABLE #spaceused ( nameout VARCHAR(50) ,rowsout int ,reservedout VARCHAR(50) ,dataout VARCHAR(50) ,index_sizeout VARCHAR(50) ,unusedout VARCHAR(50) ) 2) Send the results to the table, using sp_spaceused  I also created a script to generate about 100 of these INSERTs INSERT INTO #spaceused EXEC sp_spaceused N'TableName' ; GO 3) Query the results... SELECT TOP 10 * FROM #spaceused 4) Delete the temp table when done.  DROP TABLE #spaceused
Post a Comment
Read more

Send a powershell object straight to SQL Server

Recently I needed to copy directory contents details to an SQL Server. This is the powershell script I used to do it. $path = "C:\Files\" $Table  = Get-ChildItem -Path $path |  Select-Object Name , FullName , CreationTime , Length Write-SqlTableData -ServerInstance "PBRUCE-DT" -DatabaseName "PlayDatabase" -SchemaName "dbo" -TableName "FileInfoArchive" -InputData $Table  -Force
Post a Comment
Read more

Powershell Active Directory - User and Group

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
Post a Comment
Read more

Get a list of MSSQL processes and their sql text

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
Post a Comment
Read more