Profile cover photo
Profile photo
Yogesh Ranade
60 followers
60 followers
About
Posts

Post has attachment
JIRA Query users mentioned in issue using JQL
project = "KEY" and (summary ~ currentUser() OR description ~ currentUser() OR comment ~ currentUser()) and updatedDate >= -7d

Post has attachment
Convert Oracle date to int using native Microsoft date
SQL Server/Excel select getdate() 'Today',convert(int,getdate()) 2016-11-14 16:05:35.207 42687 Oracle select current_date,cast(current_date - date '1900-01-01' as int) from dual; 14-NOV-16 42687

Post has attachment
Oracle subtract days/Hours from current timestamp
select to_timestamp(to_char(systimestamp + INTERVAL '-1' DAY, 'dd-mon-yy hh.mi.ss.ff4 AM')) from dual; ------ -1 day select to_timestamp(to_char(systimestamp + INTERVAL '-2' HOUR, 'dd-mon-yy hh.mi.ss.ff4 AM')) from dual; ----- -2 hours current date time sel...

Post has attachment
Change Linux root user password of Cloudera Hadoop nodes
Cloudera Manager only uses the root credentials when
adding a new node to the cluster. Once the node has been added and the Cloudera
Manager agent deployed the server will no longer use the root credentials. i.e.  Once your
cluster is set up, you can safely...

Post has attachment
Splunk useful commands
put cluster in maintenance mode $SPLUNK_HOME/bin/splunk enable maintenance-mode

Post has attachment
Command to recursively delete files older than N days
forfiles -p "D:\Splunk_Data_logs\Splunk_Inputs" -s -m . /D -12 /C "cmd /c del @path"

Post has attachment
List of Splunk universal forwarders with client OS & version
index=_internal source=*metrics.log group=tcpin_connections | eval sourceHost=if(isnull(hostname), sourceHost,hostname) | dedup sourceHost | table sourceHost sourceIP os version | sort version

Post has attachment
Linux Commands
List all Linux users cut -d: -f1 /etc/passwd set password never to expire chage -I -1 -m 0 -M 99999 -E -1 username

Post has attachment

Post has attachment
Wait while more posts are being loaded