Wednesday 13 October 2010

Windows : More RDP-related commands

Connect to a share to get an admin connections
* net use /user:targetdomain\administrator \\targetmachine

List Current Users on a machine
* quser /server:targetmachine (shows session id - better as also shows login and idle time)
* qwinsta /server:serverName
Log a user off a machine

* logoff sessionId /server:targetmachine<br />

Tuesday 5 October 2010

Sharepoint - Where is the data hidden


SELECT TOP 1000 [tp_ID]
      ,tp_author
      ,tp_version
      ,[datetime1]+8 x1
      ,[datetime2]+7 x2
      ,[datetime1]
      ,[datetime2]
      ,[nvarchar1]
      ,[nvarchar2]
      ,[nvarchar3]
      ,[nvarchar4]
      ,[nvarchar5]
      ,[nvarchar6]
      ,[nvarchar7]
      ,[datetime3]
      ,[datetime4]
      ,[datetime5]
      ,[int1]
      ,[int2]
      ,[int3]
      ,[int4]
      ,[int5]
      ,[int6]
  FROM [WSS_Content].[dbo].[AllUserData]
  where 1=1
  --and tp_ListId = 'DA7307B0-4D77-4DEE-A347-D183BE27CCC3'
  and tp_DirName = 'hr/holidays/Lists/Absences'
  and nvarchar5 = 'IT Development'
  and tp_author = 51
  and tp_ID = 709
  order by datetime1 desc