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 />

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

Perl : One liner to find files less than an hour old in a dir

perl -e 'for ( glob "./*" ) { system "ls -l $_"  if ( -M $_ <= (1/24) ) };'

iTunes Error 9808

Itunes error -9808 logging into the iTunes Music Store In Internet Explorer, go up to Tools > Internet Options. Then go to the last tab, Advanced, and scroll down to the Security section. It is the fifth box down and make sure "Check for server certificate revocation (requires restart)" is unchecked. Then access the iTunes Store.

Windows 7 : Show File types

Open Folder Options by clicking the Start button , clicking Control Panel, clicking Appearance and Personalization, and then clicking Folder Options. Click the View tab, and then, under Advanced settings, do one of the following: To hide file extensions, select the Hide extensions for known file types check box, and then click OK. To display file extensions, clear the Hide extensions for known file types

Oracle : Auditing object access in 9i

Created new audit tablespace AUDIT CREATE TABLESPACE "AUDIT" DATAFILE '/u03/volnewlivedata02/oradata/LIVE1/AUDIT_01.dbf' SIZE 4096M REUSE , '/u03/volnewlivedata02/oradata/LIVE1/AUDIT_02.dbf' SIZE 4096M REUSE NOLOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; Moved audit table - nb. original audit table is left in place create table audx tablespace "AUDIT" storage (initial 50k next 50k<br />pctincrease 0) as select * from aud$ where 1 = 2<br />rename AUD$ to AUD$$;<br />rename audx to aud$;<br />create index i_aud2;<br />on aud$(sessionid, ses$tid)<br />tablespace "AUDIT" storage(initial 50k next 50k pctincrease 0)<br /> Turned on audit of all procedural code AUDIT EXECUTE PROCEDURE BY SESSION;<br />-- To remove<br />--NOAUDIT EXECUTE PROCEDURE;<br /> Turned on audit of all table access AUDIT DELETE TABLE, INSERT TABLE, SELECT TABLE, UPDATE TABLE BY SESSION;<br />-- To remove<br />--NOAUDIT DELETE TABLE, INSERT TABLE, SELECT TABLE, UPDATE TABLE BY SESSION;<br /> Review space usage carefully [ Show » ] Peter Lawes added a comment - 19/Aug/10 10:47 AM Created new audit tablespace AUDIT CREATE TABLESPACE "AUDIT" DATAFILE '/u03/volnewlivedata02/oradata/LIVE1/AUDIT_01.dbf' SIZE 4096M REUSE , '/u03/volnewlivedata02/oradata/LIVE1/AUDIT_02.dbf' SIZE 4096M REUSE NOLOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO; Moved audit table - nb. original audit table is left in place create table audx tablespace "AUDIT" storage (initial 50k next 50k pctincrease 0) as select * from aud$ where 1 = 2 rename AUD$ to AUD$$; rename audx to aud$; create index i_aud2; on aud$(sessionid, ses$tid) tablespace "AUDIT" storage(initial 50k next 50k pctincrease 0) Turned on audit of all procedural code AUDIT EXECUTE PROCEDURE BY SESSION; -- To remove --NOAUDIT EXECUTE PROCEDURE; Turned on audit of all table access AUDIT DELETE TABLE, INSERT TABLE, SELECT TABLE, UPDATE TABLE BY SESSION; -- To remove --NOAUDIT DELETE TABLE, INSERT TABLE, SELECT TABLE, UPDATE TABLE BY SESSION; Review space usage carefully [ Permlink | Edit | Delete | « Hide ] Peter Lawes added a comment - 19/Aug/10 11:40 AM Audit query with base_data as <br />(<br />select <br />nvl(rtrim(decode(substr(ses_actions, 1,1),'S','ALTER/')<br />||decode(substr(ses_actions, 2,1),'S','AUDIT/')<br />||decode(substr(ses_actions, 3,1),'S','COMMENT/')<br />||decode(substr(ses_actions, 4,1),'S','D/')<br />||decode(substr(ses_actions, 5,1),'S','GRANT/')<br />||decode(substr(ses_actions, 6,1),'S','INDEX/')<br />||decode(substr(ses_actions, 7,1),'S','I/')<br />||decode(substr(ses_actions, 8,1),'S','LOCK/')<br />||decode(substr(ses_actions, 9,1),'S','RENAME/')<br />||decode(substr(ses_actions,10,1),'S','S/')<br />||decode(substr(ses_actions,11,1),'S','U/')<br />||decode(substr(ses_actions,12,1),'S','REFERENCES/')<br />||decode(substr(ses_actions,13,1),'S','X/') <br />,'/'),'?') action<br />,a.*<br />from DBA_AUDIT_OBJECT a<br />)<br />select <br />username,os_username,timestamp,owner,obj_name,<br />b.* <br />from base_data b<br />where 1=1<br />and (owner not in ('SYS','ODL_DBADMIN_DBO','XDB')<br />and username not in ('SYS','DBSNMP')<br />and owner||'.'||obj_name not in ('SYSTEM.SQLPLUS_PRODUCT_PROFILE','SYSTEM.PRODUCT_PRIVS'))<br />or action like '%?%' <br />order by b.timestamp desc<br /> [ Show » ] Peter Lawes added a comment - 19/Aug/10 11:40 AM Audit query with base_data as ( select nvl(rtrim(decode(substr(ses_actions, 1,1),'S','ALTER/') ||decode(substr(ses_actions, 2,1),'S','AUDIT/') ||decode(substr(ses_actions, 3,1),'S','COMMENT/') ||decode(substr(ses_actions, 4,1),'S','D/') ||decode(substr(ses_actions, 5,1),'S','GRANT/') ||decode(substr(ses_actions, 6,1),'S','INDEX/') ||decode(substr(ses_actions, 7,1),'S','I/') ||decode(substr(ses_actions, 8,1),'S','LOCK/') ||decode(substr(ses_actions, 9,1),'S','RENAME/') ||decode(substr(ses_actions,10,1),'S','S/') ||decode(substr(ses_actions,11,1),'S','U/') ||decode(substr(ses_actions,12,1),'S','REFERENCES/') ||decode(substr(ses_actions,13,1),'S','X/') ,'/'),'?') action ,a.* from DBA_AUDIT_OBJECT a ) select username,os_username,timestamp,owner,obj_name, b.* from base_data b where 1=1 and (owner not in ('SYS','ODL_DBADMIN_DBO','XDB') and username not in ('SYS','DBSNMP') and owner||'.'||obj_name not in ('SYSTEM.SQLPLUS_PRODUCT_PROFILE','SYSTEM.PRODUCT_PRIVS')) or action like '%?%' order by b.timestamp desc

Excel : Remove all hyperlinks

In the spreadsheet * Press Alt-F11 to open the VB macro editor * Select the required sheet * Enter the following macro code Sub ZapHyperlinks()     Cells.Hyperlinks.Delete End Sub * Run the code - Green triangle or Menu->Run->Run Macro or F5 (possibly) * This should remove all hyperlinks in the entire sheet