Following my moment of recklessness the other night, I have been able to find a much more recent backup file which has now been restored. All posts up to the start of May are back, and I have kept the ones I entered in May.
I will still be working to restore the missing posts I have entered in May; at this point I am down only six posts which I will try to get back. The SQL Installation ones I may need to rewrite, but I still have the screenshots so that shouldn’t be too difficult.
The first of the security SQL views I am posting in this series shows all of the users and the companies to which they have been granted access.
CREATE VIEW [dbo].[uv_AZRCRV_UserAccessAndGranted] AS
/*
Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (https://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 2.0 UK: England & Wales (CC BY-NC-SA 2.0 UK).
*/
SELECT
['User Master'].USERID AS 'User ID'
,['User Master'].USERNAME AS 'Username'
,['User Master'].USRCLASS AS 'User Class'
,ISNULL(['Class Master'].DSCRIPTN, '') AS 'User Class Description'
,ISNULL(['Company Master'].INTERID, '') AS 'Intercompany ID'
,ISNULL(['Company Master'].CMPNYNAM, '') AS 'Company Name'
FROM
SY01400 AS ['User Master']
LEFT JOIN
SY40400 AS ['Class Master']
ON ['Class Master'].USRCLASS = ['User Master'].USRCLASS
LEFT JOIN
SY60100 AS ['User-Company Access']
ON ['User-Company Access'].USERID = ['User Master'].USERID
LEFT JOIN SY01500 AS ['Company Master']
ON ['Company Master'].CMPANYID = ['User-Company Access'].CMPANYID
GO
GRANT SELECT ON uv_AZRCRV_UserAccessAndGranted TO DYNGRP
GO
Back in November I posted a SQL View which could be used in SmartList Designer to return the users, company and role assignments. This view is now accompanied by several others which allow for reporting on the Dynamics GP security setup at several different levels.
These have been done as SQL views so they can easily be plugged into SmartList Designer which does not have an import/export function, but they can also be used in SmartList Builder, should the client be licensed for this add-on, or any other reporting tool.
One moment of sheer recklessness tonight saw me accidentally delete the database for this site.
To further compound the error, the most recent backup I can find is from the end of December (December 21 to be exact).
I have restored this database and will be adding back in the missing posts which were syndicated to the Dynamics GP Community and also the Perfect Image Dynamics GP site.
Unfortunately, I will not be able to recover the comments, pings or trackbacks which were received after the 21st December 2014. I will also go through all of the pages looking for missing changes I have made elsewhere.
Off the top of my head the only items I remember changing was the links page where I will have added Beat Bucher and Mahmoud al Saudis blogs to the MVP section; if you do see anything which looks wrong or has missing content, please use the Contact Us form to let me know.
Finally, please learn from my error and make regular backups of your site; and also keep a track of those backups so you know where they are and can access them quickly.