PCounter: access users database on Pcounter server

Pconter administrator Utility – Preferences – Global settings and change server name to Pconter server.

Advertisements

Windows 2008: Hibernation

powercfg.exe /hibernate off

Altiris client uninstall

C:\Program Files\Altiris\Altiris Agent\AeXAgentUtil.exe /uninstallagents /clean

SQL: tables size in database

EXEC sp_msforeachtable “sp_spaceused ‘?'”

SharePoint: all document from all lists availabe in WebApplication

SELECT AllDocs.Leafname AS ‘FileName’,
AllDOcs.Dirname AS ‘Folder Path’,
AllLists.tp_Title AS ‘List Title’,
Webs.Title AS ‘Web Title’,
AllDocs.Size AS ‘Size’
FROM AllDocs
JOIN AllLists
ON
AllLists.tp_Id=AllDocs.ListId
JOIN Webs
ON
Webs.Id=AllLists.tp_WebId
ORDER BY AllDocs.Size