MSSQL SERVER – Script to Identify Memory Used By Each Database
MSSQL SERVER – Script to Identify Memory Used By Each Database
-- Memory used by each database SELECT DB_NAME(database_id), COUNT (1) * 8 / 1024 AS MBUsed FROM sys.dm_os_buffer_descriptors GROUP BY database_id ORDER BY COUNT (*) * 8 / 1024 DESC GO
Domain Migration
Domain Migration
User Profile Wizard Release 24
User Profile Wizard Release 24 is the latest version of ForensiT's powerful workstation domain migration tool. User Profile Wizard will migrate your current user profile to your new domain, Azure AD, or local, user account so that you can keep all your existing data and settings.
Read our User Profile Wizard Feature Comparison to find out what additional features are available in the Corporate and Professional editions. If you would like to evaluate the Corporate Edition of User Profile Wizard please contact This email address is being protected from spambots. You need JavaScript enabled to view it..
Find out more
Download User Profile Wizard R24 Freeware Edition for Windows 10, Windows 11, and Windows 7
Download User Profile Wizard Freeware Edition for Windows XP
Download User Profile Wizard Corporate Edition User Guide
End User License Agreement
User Profile Wizard Freeware Edition is a standalone executable; it does not need to be installed or uninstalled. Download and run the msi file to extract the Profwiz.exe file.
Exporting Tree AD Groups with members to csv
Exporting Tree AD Groups with members to csv
Print on the screen:
$group = @{
filter = "GroupCategory -eq 'security'"
SearchBase = "OU=Security Groups,DC=Domainname,DC=local"
properties = "members"
}
get-adgroup @group |
select @{n='GroupName';e={$_.samaccountname}},
@{n='Name';e={($_.members | get-adobject).name -join "`n"}}
Print to csv file - export.csv:
$group = @{
filter = "GroupCategory -eq 'security'"
SearchBase = "OU=Group Name,DC=Domain,DC=Domain"
properties = "members"
}
get-adgroup @group |
select @{n='GroupName';e={$_.samaccountname}},
@{n='Name';e={($_.members | get-adobject).name -join "`n"}} |
export-csv "export.csv" -notypeinformation -Force
With UTF-8:
$group = @{
filter = "GroupCategory -eq 'security'"
SearchBase = "OU=Security Groups,DC=Domainname,DC=local"
properties = "members"
}
get-adgroup @group |
select @{n='GroupName';e={$_.samaccountname}},
@{n='Name';e={($_.members | get-adobject).name -join "`n"}} |
export-csv "groupexport.csv" -notypeinformation -Force -Encoding UTF8




