Download SQL patch Info

  • Theo Ekelmans

    SSCarpal Tunnel

    Points: 4482

    Comments posted to this topic are about the item Download SQL patch Info

  • Alberto Turelli

    Old Hand

    Points: 359

    Nice job, Theo, it seems a timesaving activity, so I'm trying it out on a development machine.

    For the moment I'd only suggest to modify the CreateServerInfoDbAndTables.sql file, inserting a USE [ServerInfo] statement just before creating the tables, or you'll end up messing with the master database.

  • Theo Ekelmans

    SSCarpal Tunnel

    Points: 4482

    Alberto Turelli - Monday, July 3, 2017 2:05 AM

    Nice job, Theo, it seems a timesaving activity, so I'm trying it out on a development machine.

    For the moment I'd only suggest to modify the CreateServerInfoDbAndTables.sql file, inserting a USE [ServerInfo] statement just before creating the tables, or you'll end up messing with the master database.

    Good point. Adding it now 🙂

  • Lowell

    SSC Guru

    Points: 323444

    Nice job Theo;
    I had created a procedure to check the current patch version,all available patch version, and the suggested Service pack version, but it used an internally contained CTE full of static values from the last time I downloaded and formatted that information.
    If I can twist my proc around to use your table, I'll post it so you can add it to your solution.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Theo Ekelmans

    SSCarpal Tunnel

    Points: 4482

    Thanks Lowell 🙂

    I'd like to see what you come up with.

  • christoffersen366

    Old Hand

    Points: 373

    Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same result and changing the link and still nothing.

  • Mr. Brian Gale

    SSC-Insane

    Points: 22519

    christoffersen366 - Wednesday, July 5, 2017 8:16 AM

    Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same result and changing the link and still nothing.

    I had that at first too.  Is your wget set up properly?  you need 3 files for it to work properly: the wget.exe and 2 dll's.

    I have this working in one of our test instances and am now building up a stored procedure that goes out and queries all of the other servers to see what version they are on and then builds up a result to indicate if I am behind or not.
    On the test systems, most of mine are a little bit behind, but not terrible.

    Thanks a bunch for the script!

  • Theo Ekelmans

    SSCarpal Tunnel

    Points: 4482

    christoffersen366 - Wednesday, July 5, 2017 8:16 AM

    Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same result and changing the link and still nothing.

    You could try to execute WGET in a comd windows first to check if that step is working

    Maybe some firewall is blocking you?  🙂

  • Theo Ekelmans

    SSCarpal Tunnel

    Points: 4482

    I'm thinking of adding a second HTML scraper, and add the SQL EOL date columns.

    Usefull ?  Not Usefull?

    What do you guys think ?

  • Robert Sterbal

    SSChampion

    Points: 10979

    Has anyone found the equivalent tool for Windows patches?

    412-977-3526 call/text

  • Mr. Brian Gale

    SSC-Insane

    Points: 22519

    Theo Ekelmans - Thursday, July 6, 2017 4:55 AM

    I'm thinking of adding a second HTML scraper, and add the SQL EOL date columns.

    Usefull ?  Not Usefull?

    What do you guys think ?

    robert.sterbal 56890 - Thursday, July 6, 2017 12:39 PM

    Has anyone found the equivalent tool for Windows patches?

    Theo - that sounds useful to me 🙂
    Robert - There are tools out there that will do this for you.  Where I work, we have a tool called "Desktop Central" that will allow you to look at and install patches on windows machines.  It is not a free tool, but I imagine you could build something using Powershell and WMI.

  • christoffersen366

    Old Hand

    Points: 373

    bmg002 - Wednesday, July 5, 2017 11:08 AM

    christoffersen366 - Wednesday, July 5, 2017 8:16 AM

    Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same result and changing the link and still nothing.

    I had that at first too.  Is your wget set up properly?  you need 3 files for it to work properly: the wget.exe and 2 dll's.

    I have this working in one of our test instances and am now building up a stored procedure that goes out and queries all of the other servers to see what version they are on and then builds up a result to indicate if I am behind or not.
    On the test systems, most of mine are a little bit behind, but not terrible.

    Thanks a bunch for the script!

    Just got it without those files, I didn't want to challenge my firewall, it's very strict.

    Theo Ekelmans - Thursday, July 6, 2017 4:53 AM

    christoffersen366 - Wednesday, July 5, 2017 8:16 AM

    Nice project. But I'm not getting anything in the @html variable, the html file is empty. It can reach the site and I've tried another path without spaces with same result and changing the link and still nothing.

    You could try to execute WGET in a comd windows first to check if that step is working

    Maybe some firewall is blocking you?  🙂

    Thanks. While typing it in I realized the file I downloaded was called wget64.exe while the name in the script is just wget.exe 🙂
    Now it gets the data from the site, but when putting it into the tblBuildListImport, it either gives me an error because it isn't there or because it is, and doesn't seem to go any further, the table is empty.
    But I just got past the former issue so I might find out in a bit.

  • christoffersen366

    Old Hand

    Points: 373

    Got it to work after rewriting the line that drops the import table if its ID is null, to dropping it if it exists. Select into can't work if it's there, and Insert into instead would be more work since there's an ID column.
    This could result in it deleting the table and remaking it with nothing, if it runs without net access for example, so @out should be checked too.
    Again, great work.

  • Theo Ekelmans

    SSCarpal Tunnel

    Points: 4482

    christoffersen366 - Friday, July 7, 2017 5:03 AM

    Got it to work after rewriting the line that drops the import table if its ID is null, to dropping it if it exists. Select into can't work if it's there, and Insert into instead would be more work since there's an ID column.
    This could result in it deleting the table and remaking it with nothing, if it runs without net access for example, so @out should be checked too.
    Again, great work.

    Thanks for the feedback 🙂

  • Robert Sterbal

    SSChampion

    Points: 10979

    bmg002 - Thursday, July 6, 2017 12:53 PM

    Theo Ekelmans - Thursday, July 6, 2017 4:55 AM

    I'm thinking of adding a second HTML scraper, and add the SQL EOL date columns.

    Usefull ?  Not Usefull?

    What do you guys think ?

    robert.sterbal 56890 - Thursday, July 6, 2017 12:39 PM

    Has anyone found the equivalent tool for Windows patches?

    Theo - that sounds useful to me 🙂
    Robert - There are tools out there that will do this for you.  Where I work, we have a tool called "Desktop Central" that will allow you to look at and install patches on windows machines.  It is not a free tool, but I imagine you could build something using Powershell and WMI.

    I'm looking for a list of patches by OS. Once I have the source I'll be able to process it, but I'm finding it hard to find a source.

    412-977-3526 call/text

Viewing 15 posts - 1 through 15 (of 45 total)

You must be logged in to reply to this topic. Login to reply