DataBase, 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 […]

Read more
DataBase, 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] .

Read more
DataBase, PowerShell

PowerShell Script to Update MS Access (.MBD) Database

PowerShell Script to Update MS Access (.MBD) Database [code language=”powershell”] ########################################################################### # # NAME: Update-MSAccessDB-Via-UserDSN # # AUTHOR: Govardhan Gunnala # # COMMENT: # 1. Updates MDB file records via "MS Access Database" User DSN # 2. Creates "MS Access Database" USER DSN if not already exists # 3. Sets the "MS Access Database" USER DSN to custom .MDB file # 4. Process all the data Column by Column # 5. Searches and Replaces a partial string in whole table data # # # VERSION HISTORY: 1.0 7/18/2011 – Initial release # ########################################################################### # Import Registry Keys to create a […]

Read more