I had an issue where a server which was joined to a domain had incorrectly set its network as Public. A TechNet article and TenForum article provided the answer (As it states Windows 10 it also applies to Server 2012) so I have placed credits above the steps I followed. Following a re-occurrence I have […]
The Event Viewer from Server 2008 onwards is XML based. Filters based on XML syntax can be used such as:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<QueryList> <Query Id="0" Path="System"> <Select Path="System"> *[EventData[Data and (Data='<Search Parameter>')]] </Select> </Query> </QueryList> <QueryList> <Query Id="0" Path="Application"> <Select Path="Application"> *[EventData[Data and (Data='<Search Parameter>')]] </Select> </Query> </QueryList> |
You can search for anything which appears in the data section such as service names, error messages etc..
|
1 2 3 4 5 6 7 |
- <EventData> <Data Name="param1">Service Display Name</Data> <Data Name="param2">Details</Data> <Data Name="param3">Details</Data> <Data Name="param4">Service Name</Data> </EventData> </Event> |
Notes: MS Technet
Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500 and Datalinx WHM (Although its easy enough to change, the first “set @SSCC” basically gets the digits, the rest of the code simply calculates the check digit). This proc uses the Datalinx WHM Pallet ID […]
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do this even with users off I was being shown errors stating it must be done in Single User Mode. I decided I wanted to do this as quickly as possible so slapped together some SQL […]
I had a user unable to use a script which generated an email, I found the user didn’t have permission, Microsoft state: To reduce the surface area of SQL Server, Database Mail stored procedures are disabled by default. To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb […]
A while ago we added error trapping to the batch file called by a SQL script, this was to ensure if a program failed the rest of the process would not run: After ensuring the program would return an error level if something went wrong we then I then used the ErrorLevel and an if […]
Credits (As what I consider the hard stuff was actually done by other people): TheSmileyCoder for the solid awesome little VBS File, this basically gets around the limitation of not actually getting Access to load another Access Database. At the time I only ever needed one modification (A rarely issue affected two P4 machines with […]
Nearly every single Microsoft Access “database” I use has a proper database attached instead of using the internal Jet Engine, this means data is not actually stored in the Access “database” and I therefore call them Access Frontends. Compiling your Access front ends to ACCDE provides a compiled copy of your Access Front End. I […]
I needed to run a scheduled batch job and kill it off after a certain amount of time, this was because the program would run what it needed and then run as normal (If it exists then there is no reason to use start or timeout). As it actually ran as a service I didn’t […]
We had a number of nsf files given to us by a company we had purchased, however they utilised Shared Mails and the resulting Notes Files contained lots of missing attachments. A process of de-linking needed to be run to basically tell Domino to copy shared items back to the nsf file and not to […]