Scripting – Page 9

June 4, 2014August 12, 2014DataBase, Scripting

SQL Programming: Convert UTC Time to Local Time

Most of todays enterprise software’s get data gathered from workstations located various parts of the world that run in different time zones. To ensure the data integrity and proper processing of events/information, software’s rely on saving the date data in UTC and then convert them at run time for reporting. When you have to run queries manually, you need to take care of this note and as well need to convert the date data into your local time and here is a quick trick that can help you. [code language=”sql”] –You can calculate the offset from UTC easily enough: select […]

June 4, 2014August 12, 2014DataBase, Desktop, Scripting

Symantec Endpoint Protection (SEP) Reporting: SQL Stored Procedure to Generate Monthly Reports

It’s the security officers responsibility to overview the firm’s infrastructure risk exposure and trends in real time. Unfortunately, none of the industry leading security products has a feature to create a consolidated risk report that can help the top security officers to review and keep track with risk events. As I’ve great exposure into SEP DB schema, I’ve developed a SQL query that generates a consolidated report in a high level format classifying the risk events into below categories: [code language=”sql”] if user name matches *admin*, report it as "Admin account access" if user name matches "system", report it as […]

June 4, 2014June 4, 2014DataBase, Visual Basic

Visual Basic Script to Query .MDB Database via “MS Access Database” User DSN

Visual Basic Script to Query .MDB Database via “MS Access Database” User DSN [code language=”vb”] Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adUseClient = 3 Set objConnection = CreateObject("ADODB.Connection") Set objRecordset = CreateObject("ADODB.Recordset") objConnection.Open "DSN=MS Access Database;" objRecordset.CursorLocation = adUseClient objRecordset.Open "SELECT * FROM Connection" , objConnection, _ adOpenStatic, adLockOptimistic objRecordset.MoveFirst() Do Until objRecordSet.EOF Wscript.Echo "Connection Name: " & objRecordSet.Fields("ConnectName").Value objRecordSet.MoveNext Loop objRecordset.Close objConnection.Close [/code] .