• Luis Cazares (7/22/2016)


    Brandie Tarvin (7/22/2016)


    jasona.work (7/22/2016)


    So I'm sitting here, and I just realized I've got a grin on my face from getting something to work...

    Crafting up some easy-to-use backup reports that the bosses can use to check the status of our SQL backups. Just got one to work that allows the user to specify the DATE to check for completed backups. The query was the easy part, getting it into an SSRS report was a little less easy (took me a bit and some Google-fu to realize you don't need to declare your variable in the query if you're using a parameter from the report)

    Now to make it a bit "prettier," maybe some color coding or something...

    If only I could figure out a way to pull in the server names dynamically, rather than hard-coding them in a parameter (which isn't so bad as our servers don't change all that frequently, but hey, then it keeps working even after I leave and new servers get added...)

    Next week, to annoy the Oracle DBAs and see if we can find a way to pull in THEIR backup results the same way!

    😀

    Ummm.... You could... I dunno... Use some API related to SQL Browser to pull your server list dynamically? Store the names of the exceptions (do not bother about these servers) in a table somewhere, the cross reference the two result sets?

    Wouldn't it be simpler to store the server names in a table instead of the exceptions? 😀

    Parameters can be populated from a query (if that wasn't obvious)

    Put them in an OU in active directory, then pull the list.

    The issue you could run into depends on how date is used.

    I used to do something similar to help the network guys match scans to look for missing ones.

    Much better than the manually maintained list they were using at the time.

    Especially as servers were added and replaced.