builds.html

<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="initial-scale=1.0, maximum-scale=2.0">
    <title>SQL Server builds, powered by dbatools</title>
    <link rel="icon" href="https://dbatools.io/wp-content/uploads/2016/05/dbatools.png" sizes="32x32">
    <link rel="icon" href="https://dbatools.io/wp-content/uploads/2016/05/dbatools.png" sizes="192x192">
    <link rel="apple-touch-icon-precomposed" href="https://dbatools.io/wp-content/uploads/2016/05/dbatools.png">
    <meta name="msapplication-TileImage" content="https://dbatools.io/wp-content/uploads/2016/05/dbatools.png">
    <meta name="twitter:image" content="https://dataplat.github.io/assets/thumbnail.png">
    <meta name="twitter:card" content="summary_large_image">
    <meta property="og:locale" content="en_US">
    <meta property="og:type" content="website">
    <meta name=description content="Covers SQL Server 2000-2022">
    <meta name=twitter:creator content="@psdbatools">
    <meta name=twitter:title content="SQL Server builds, powered by dbatools">
    <meta property="twitter:site" content="@psdbatools" />

    <meta property="og:url" content="https://dbatools.io/builds">
    <meta property="og:title" content="SQL Server builds, powered by dbatools">
    <meta property="og:description" content="Covers SQL Server 2000-2022">
    <meta property="og:image" content="https://dataplat.github.io/assets/thumbnail.png">
    <meta name=keywords content="powershell,sql server,devops,json">
    <link rel=apple-touch-icon sizes=180x180 href=https://dbatools.io/wp-content/uploads/2016/05/dbatools.png>
    <link rel=canonical href=https://dbatools.io/builds />
    <link rel=alternate type=application/json
        href=https://raw.githubusercontent.com/dataplat/dbatools/development/bin/dbatools-buildref-index.json
        title="SQL Server builds">

    <!-- Global site tag (gtag.js) - Google Analytics -->
    <script async src="https://www.googletagmanager.com/gtag/js?id=G-Y0BPEL0VKL"></script>
    <script>
        window.dataLayer = window.dataLayer || [];
        function gtag() { dataLayer.push(arguments); }
        gtag('js', new Date());

        gtag('config', 'G-Y0BPEL0VKL');
    </script>

    <link rel="stylesheet" type="text/css"
        href="//cdn.datatables.net/w/bs4-4.1.1/jq-3.3.1/jszip-2.5.0/dt-1.10.18/b-1.5.6/b-html5-1.5.6/cr-1.5.0/fc-3.2.5/fh-3.1.4/r-2.2.2/datatables.min.css">
    <style>
        .customnav {
            background: #e3e3e3
        }

        body {
            min-height: 75rem;
        }

        h2 small.text-muted {
            font-size: 50%;
        }

        @media (max-width: 575px) {
            .hidden-xs-down {
                display: none !important;
            }
        }

        @media (min-width: 575px) {
            .hidden-xs-up {
                display: none !important;
            }
        }
    </style>
    <script type="text/javascript" language="javascript"
        src="//cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js"></script>
    <script type="text/javascript" language="javascript"
        src="//cdn.datatables.net/w/bs4/jq-3.3.1/jszip-2.5.0/dt-1.10.18/b-1.5.6/b-html5-1.5.6/cr-1.5.0/fc-3.2.5/fh-3.1.4/r-2.2.2/datatables.min.js"></script>
    <script type="text/javascript" language="javascript"
        src="//cdn.jsdelivr.net/npm/lodash@4.17.4/lodash.min.js"></script>

    <script type="text/javascript" language="javascript">
        $(document).ready(function () {
            var t = $('#buildref').DataTable({
                responsive: true,
                fixedHeader: true,
                dom: 'Bfrtip',
                buttons: [
                    'copy', 'excel', 'pdf'
                ],
                "order": [0, 'desc'],
                "lengthMenu": [[25, 50, 100, -1], [25, 50, 100, "All"]],
                "pageLength": 100,
                "columnDefs": [
                    {
                        "targets": [0],
                        "visible": false,
                        "searchable": false
                    },
                    {
                        "targets": [6, 7, 8, 9],
                        "className": "text-center",
                        "render": function (data, type, row, meta) {
                            return data == 'X' ? '&#10003;' : '';
                        }
                    },
                    {
                        "targets": [3, 4, 5, 10],
                        "render": function (data, type, row, meta) {
                            return data == '.' ? '' : data;
                        }
                    }
                ]
            });
            $('button.filterName').on('click', function () {
                var filtername = $(this).data('filtervalue').toString()
                if (filtername.length > 0) {
                    filtername = '^' + filtername + '$';
                }
                t.columns(2)
                    .search(filtername, true, false)
                    .draw();
                $('button.filterName').removeClass('active')
                $(this).addClass('active');

            })
            function resetfilterattr() {
                t.columns(6).search("")
                    .columns(7).search("")
                    .columns(8).search("")
                    .columns(9).search("")
                    .draw();
            }
            $('button.filterSP').on('click', function () {
                resetfilterattr()
                if ($(this).hasClass('active')) {
                    $('button.filterattr').removeClass('active')
                } else {
                    $('button.filterattr').removeClass('active')
                    $(this).addClass('active')
                    t.columns(6)
                        .search($(this).data('filtervalue'))
                        .draw();
                }

            })
            $('button.filterCU').on('click', function () {
                resetfilterattr()
                if ($(this).hasClass('active')) {
                    $('button.filterattr').removeClass('active')
                } else {
                    $('button.filterattr').removeClass('active')
                    $(this).addClass('active')
                    t.columns(7)
                        .search($(this).data('filtervalue'))
                        .draw();
                }
            })
            $('button.filterLatestSP').on('click', function () {
                resetfilterattr()
                if ($(this).hasClass('active')) {
                    $('button.filterattr').removeClass('active')
                } else {
                    $('button.filterattr').removeClass('active')
                    $(this).addClass('active')
                    t.columns(8)
                        .search($(this).data('filtervalue'))
                        .draw();
                }
            })
            $('button.filterLatestCU').on('click', function () {
                resetfilterattr()
                if ($(this).hasClass('active')) {
                    $('button.filterattr').removeClass('active')
                } else {
                    $('button.filterattr').removeClass('active')
                    $(this).addClass('active')
                    t.columns(9)
                        .search($(this).data('filtervalue'))
                        .draw();
                }
            })
            $.ajax({
                dataType: "json",
                url: 'https://dataplat.github.io/assets/dbatools-buildref-index.json',
                success: function (data) {
                    $('h2 small.text-muted').text('updated on ' + data.LastUpdated.substring(0, 10))
                    var newarr = []
                    var prevName = '.'
                    var prevSP = '.'
                    var prevCU = '.'
                    var prevSupportedUntil = '.'
                    var prevrow = null
                    var results = [];
                    _.forEach(data.Data, function (el, i) {
                        var is_SP = '.'
                        var is_CU = '.'
                        var is_LatestCU = '.'
                        if (el.Name && el.Name.length > 3) {
                            if (el.Name != prevName) {
                                prevName = el.Name
                                prevSP = '.'
                                prevCU = '.'
                                is_LatestCU = 'X'
                                prevSupportedUntil = '.'
                            }
                        }
                        if (el.SP) {
                            is_SP = 'X'
                            var compareSP = el.SP
                            if (compareSP != prevSP) {
                                prevSP = compareSP
                                prevCU = '.'
                                is_LatestCU = 'X'
                                prevSupportedUntil = '.'
                            }
                        }
                        if (el.CU && el.CU.length > 2) {
                            is_CU = 'X'
                            if (el.CU != prevCU) {
                                prevCU = el.CU
                            }
                        }
                        if (el.SupportedUntil && el.SupportedUntil.length > 2) {
                            if (el.SupportedUntil != prevSupportedUntil) {
                                prevSupportedUntil = el.SupportedUntil.substring(0, 10)
                            }
                        }
                        var nKBList = '.'
                        if (el.KBList) {
                            if (_.isArray(el.KBList)) {
                                var KBArr = []
                                for (var kbl = 0; kbl < el.KBList.length; kbl++) {
                                    KBArr.push('<a target="_blank" href="https://duckduckgo.com/?q=kb' + el.KBList[kbl] + '">KB' + el.KBList[kbl] + '</a>')
                                }
                                nKBList = KBArr.join()
                            } else {
                                nKBList = '<a target="_blank" href="https://duckduckgo.com/?q=kb' + el.KBList + '">KB' + el.KBList + '</a>'
                            }
                        }
                        if (prevSP.indexOf('LATEST') !== -1) {
                            //is_LatestSP = 'X'
                            prevSP = prevSP.filter(el => el != 'LATEST')
                        }

                        if (is_LatestCU !== '.') {
                            if (results.length > prevrow) {
                                if (results[prevrow][7] !== '.') {
                                    results[prevrow][9] = 'X'
                                }
                            }
                        }

                        prevrow = i
                        if (el.Retired) {
                            var niceVersion = el.Version + ' (Retired)'
                        } else {
                            var niceVersion = el.Version
                        }
                        results.push(
                            [i, niceVersion, prevName, prevSP, prevCU, prevSupportedUntil, is_SP, is_CU, '.', '.', nKBList]
                        )
                    })
                    var datareverse = _.reverse(results.slice())
                    var spdata = _.filter(datareverse, function (o) { return o[6] === 'X' })
                    var lastrel = ''
                    _.forEach(spdata, function (el, i) {
                        if (el[2] != lastrel && el[1].indexOf('Retired') === -1) {
                            results[el[0]][8] = 'X'
                            lastrel = el[2]
                        }
                    })
                    var cudata = _.filter(datareverse, function (o) { return o[7] === 'X' })
                    var lastrel = ''
                    _.forEach(cudata, function (el, i) {
                        if (el[2] + el[3] != lastrel && el[1].indexOf('Retired') === -1) {
                            results[el[0]][9] = 'X'
                            lastrel = el[2] + el[3]
                        }
                    })
                    t.rows.add(results)
                    t.draw(false)
                }
            });


        });

    </script>
</head>


<body>

    <nav class="navbar navbar-expand-md customnav">
        <a href="https://dbatools.io/" class="navbar-brand" rel="home" itemprop="url">
            <img width="265" height="64" src="https://dbatools.io/wp-content/uploads/2016/05/dbatools-logo-1.png"
                class="custom-logo" alt="dbatools" itemprop="logo" scale="0">
        </a>
        <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarCollapse"
            aria-controls="navbarCollapse" aria-expanded="false" aria-label="Toggle navigation">
            <span class="oi oi-menu"></span>
        </button>
        <div class="collapse navbar-collapse flex-grow-1 text-right" id="navbarCollapse">
            <ul class="navbar-nav ml-auto flex-nowrap">
                <li class="nav-item">
                    <a class="nav-link" style="color:#293E5D"
                        href="https://github.com/dataplat/dbatools/blob/development/bin/dbatools-buildref-index.json">📔
                        JSON file</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" style="color:#293E5D" href="https://dbatools.io/download/">⬇ download
                        dbatools</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" style="color:#293E5D" href="https://dbatools.io/team/">🧑‍💻 team</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" style="color:#293E5D" href="https://dbatools.io/slack">🔍 find us</a>
                </li>
                <li class="nav-item">
                    <a class="nav-link" style="color:#293E5D" href="https://dbatools.io/book">📘 dbatools book</a>
                </li>
            </ul>
        </div>
    </nav>

    <div class="container-fluid">
        <div class="row">
            <div class="col">
                <h2>SQL Server Build Reference
                    <small class="text-muted"></small>
                </h2>
            </div>
        </div>
        <div class="row">
            <div class="col version filter">
                <h5>Filter by SQL Version</h5>
                <div class="btn-group hidden-xs-down" role="group">
                    <button class="btn btn-primary filter filterName" data-filtervalue="2000">2000</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2005">2005</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2008">2008</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2008R2">2008R2</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2012">2012</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2014">2014</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2016">2016</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2017">2017</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2019">2019</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2022">2022</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="">All</button>
                </div>
                <div class="btn-group btn-group-vertical hidden-xs-up" role="group">
                    <button class="btn btn-primary filter filterName" data-filtervalue="2000">2000</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2005">2005</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2008">2008</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2008R2">2008R2</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2012">2012</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2014">2014</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2016">2016</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2017">2017</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2019">2019</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="2022">2022</button>
                    <button class="btn btn-primary filter filterName" data-filtervalue="">All</button>
                </div>
            </div>
            <div class="col attribute filter">
                <h5>Filter by Attributes</h5>
                <div class="btn-group hidden-xs-down" role="group">
                    <button class="btn btn-secondary filter filterattr filterSP" data-filtervalue="&#10003;">Service
                        Packs</button>
                    <button class="btn btn-secondary filter filterattr filterCU"
                        data-filtervalue="&#10003;">CUs</button>
                    <button class="btn btn-secondary filter filterattr filterLatestSP"
                        data-filtervalue="&#10003;">Latest
                        SP</button>
                    <button class="btn btn-secondary filter filterattr filterLatestCU"
                        data-filtervalue="&#10003;">Latest
                        CU</button>
                </div>
                <div class="btn-group btn-group-vertical hidden-xs-up" role="group">
                    <button class="btn btn-secondary filter filterattr filterSP" data-filtervalue="&#10003;">Service
                        Packs</button>
                    <button class="btn btn-secondary filter filterattr filterCU"
                        data-filtervalue="&#10003;">CUs</button>
                    <button class="btn btn-secondary filter filterattr filterLatestSP"
                        data-filtervalue="&#10003;">Latest
                        SP</button>
                    <button class="btn btn-secondary filter filterattr filterLatestCU"
                        data-filtervalue="&#10003;">Latest
                        CU</button>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col">
                <hr />
            </div>
        </div>
        <div class="row">
            <div class="col">
                <table id="buildref" class="table table-striped table-bordered table-sm" cellspacing="0" width="100%">
                    <thead>
                        <tr>
                            <th>Id</th>
                            <th>Version</th>
                            <th>Name</th>
                            <th>SP</th>
                            <th>CU</th>
                            <th>End Of Support</th>
                            <th>SP &#10003;</th>
                            <th>CU &#10003;</th>
                            <th>Latest SP &#10003;</th>
                            <th>Latest CU &#10003;</th>
                            <th>KB Ref</th>
                        </tr>
                    </thead>
                    <tfoot>
                        <tr>
                            <th>Id</th>
                            <th>Version</th>
                            <th>Name</th>
                            <th>SP</th>
                            <th>CU</th>
                            <th>End Of Support</th>
                            <th>SP &#10003;</th>
                            <th>CU &#10003;</th>
                            <th>Latest SP &#10003;</th>
                            <th>Latest CU &#10003;</th>
                            <th>KB Ref</th>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>

    </div>
    </div>
</body>

</html>