Home
- Details
- Written by: po3dno
- Category: MSSQL
- Hits: 1158
SELECT DBS.Name, AGS.AvailabilityGroupName, AGS.PrimaryReplicaServerName
FROM sys.databases DBS
LEFT JOIN
(SELECT
dbcs.database_name AS [DatabaseName],
AG.name AS [AvailabilityGroupName],
agstates.primary_replica AS [PrimaryReplicaServerName]
FROM master.sys.availability_groups AS AG
LEFT OUTER JOIN master.sys.dm_hadr_availability_group_states as agstates
ON AG.group_id = agstates.group_id
INNER JOIN master.sys.availability_replicas AS AR
ON AG.group_id = AR.group_id
INNER JOIN master.sys.dm_hadr_availability_replica_states AS arstates
ON AR.replica_id = arstates.replica_id AND arstates.is_local = 1
INNER JOIN master.sys.dm_hadr_database_replica_cluster_states AS dbcs
ON arstates.replica_id = dbcs.replica_id
LEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs
ON dbcs.replica_id = dbrs.replica_id AND dbcs.group_database_id = dbrs.group_database_id
) as AGS
ON DBS.name = AGS.DatabaseName
Order by DBS.name
- Details
- Written by: po3dno
- Category: MSSQL
- Hits: 1092
SELECT OBJECT_NAME(id) table_name, rows FROM sysindexes WHERE indid IN (0,1) order by rows desc
- Details
- Written by: po3dno
- Category: MSSQL
- Hits: 967
use [DBNAME]
EXEC sp_rename 'v8users', 'v8users_old'
GO
UPDATE Params
SET FileName = 'users.usr_old'
WHERE FileName = 'users.usr'
GO
use [DBNAME]
DROP TABLE v8users
GO
EXEC sp_rename 'v8users_old', 'v8users'
GO
UPDATE Params
SET FileName = 'users.usr'
WHERE FileName = 'users.usr_old'
GO
- Details
- Written by: po3dno
- Category: Power Shell
- Hits: 1148
# получить список mac
[System.Collections.ArrayList]$d = (Get-DhcpServerv4Policy -ScopeId 172.16.36.0 -name "Mac allow").MacAddress
# удалить MAC
$d.Remove("24-e3-14-82-6c-86")
# добавить EQ
$res = ($d | ?{$_ -ne "EQ"} | sort) -join ",EQ," -replace '^(.*)','EQ,$1' -split ","
# сохранить политику
Set-DhcpServerv4Policy -ScopeId 172.16.36.0 -Name "Mac allow" -MacAddress $res
- Details
- Written by: po3dno
- Category: Power Shell
- Hits: 1106
$user = [ADSI]"WinNT://domain/username,user"
$AdminGroup = [ADSI]"WinNT://$host/Пользователи удаленного рабочего стола,group";
$AdminGroup.Add($user.Path)