Home
- Details
- Written by: po3dno
- Category: MSSQL
- Hits: 978
declare @DbId as int = db_id(N'имя_базы') use [master]; select [now] = cast(sysdatetime() as datetime2(0)) /*, [db_name] = db_name(er.[database_id]) */ , es.session_id , er.[status] , er.command /*, [sql_command] = case when er.sql_handle is null then null else (select [text] from sys.dm_exec_sql_text(er.sql_handle)) end*/ , er.percent_complete , er.[wait_resource] , er.blocking_session_id , es.[program_name] , es.[host_name] , es.[login_name] , es.[nt_user_name] , er.start_time , er.[user_id] , er.connection_id from sys.dm_exec_requests er inner join sys.dm_exec_sessions es on es.[session_id] = er.[session_id] where er.database_id = @DbId ;
- Details
- Written by: po3dno
- Category: Power Shell
- Hits: 1158
-
Launch PowerShell and dot source function from the
Out-Minidump.ps1(note first dot):
. c:\path\to\Out-Minidump.ps1- Now you can actually create dump of the process using this syntax:
Get-Process 'notepad.exe' | Out-Minidump -DumpFilePath C:\temp- To get help, run this command:
Get-Help Out-Minidump -Full- Details
- Written by: po3dno
- Category: Power Shell
- Hits: 966
[void][reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration")
$wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::getUpdateServer("localhost",$False)
$groupall = $wsus.GetComputerTargetGroups()
$pcall = $groupall | %{$_.GetComputerTargets()}
- Details
- Written by: po3dno
- Category: Exchange Server
- Hits: 1075
Set-UserPhoto "Paul Cannon" -PictureData ([System.IO.File]::ReadAllBytes("C:\Users\Administrator\Desktop\PaulCannon.jpg"))
- Details
- Written by: po3dno
- Category: C#
- Hits: 1086
string pc = System.Environment.MachineName;
if (args.Count() == 1)
pc = args[0];
// Ограничение на поле class = 33 символа
string[] List = new string[] {
"Win32_BaseBoard",
"Win32_BIOS",
"Win32_ComputerSystem",
//"Win32_Environment",
"Win32_LogicalDisk",
"Win32_NetworkAdapter",
"Win32_OperatingSystem",
"Win32_NetworkAdapterConfiguration"
};