Home
- Details
- Written by: po3dno
- Category: MSSQL
- Hits: 812
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: 719
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: 831
# получить список 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: 787
$user = [ADSI]"WinNT://domain/username,user"
$AdminGroup = [ADSI]"WinNT://$host/Пользователи удаленного рабочего стола,group";
$AdminGroup.Add($user.Path)
- Details
- Written by: po3dno
- Category: Power Shell
- Hits: 802
$ObjUser = [ADSI]"WinNT://$computer/$user"
$ObjUser.IsAccountLocked = $false