{"id":771,"date":"2020-04-02T12:02:31","date_gmt":"2020-04-02T10:02:31","guid":{"rendered":"https:\/\/cecetka.cp2.tuke.sk\/uvt\/wordpress\/?p=771"},"modified":"2020-04-15T10:55:27","modified_gmt":"2020-04-15T08:55:27","slug":"6-reporty","status":"publish","type":"post","link":"https:\/\/robert.cecetka.website.tuke.sk\/?p=771","title":{"rendered":"6 Reporty"},"content":{"rendered":"\n

Sl\u00fa\u017eia na vytvorenie preh\u013eadov v ESMC, ako s\u00fa pridelen\u00e9 licencie, PC\/NB \u017eiadaj\u00face licenciu a r\u00f4znych in\u00fdch preh\u013eadov.<\/p>\n\n\n\n

Bohu\u017eia\u013e som zistil, \u017ee nie je mo\u017en\u00e9 vytvori\u0165 niektor\u00e9 preh\u013eady. Hlavne preh\u013ead PC , ktor\u00fdch zanikol pou\u017e\u00edvate\u013e a u\u017e nie je pridelen\u00fd dan\u00e9mu PC resp. NB. Na toto zistenie som vytvoril SQL dotaz, ktor\u00fd to vyp\u00ed\u0161e.<\/p>\n\n\n\n

SQL dotazy<\/strong><\/h2>\n\n\n\n

Pozri aj \u010dl\u00e1nok: 10.5 Vykonanie SQL dotazu cez Webmin.<\/a><\/p>\n\n\n\n

Zistenie po\u010dtu naimportovan\u00fdch pou\u017e\u00edvate\u013eov z AD.TUKE.SK<\/p>\n\n\n\n

SELECT COUNT(*) FROM era_db.tbl_staff_user where removed=0;<\/p><\/blockquote>\n\n\n\n

V\u00fdpis naimportovan\u00fdch pou\u017e\u00edvate\u013eov z AD.TUKE.SK<\/p>\n\n\n\n

SELECT * FROM era_db.tbl_staff_user where removed=0;<\/p><\/blockquote>\n\n\n\n

V\u00fdpis PC\/NB bez pridelen\u00e9ho pou\u017e\u00edvate\u013ea z AD.TUKE.SK<\/p>\n\n\n\n

<\/p>\n\n\n\n

mssql-select<\/a>Stiahnu\u0165<\/a><\/div>\n\n\n\n
mysql-select<\/a>Stiahnu\u0165<\/a><\/div>\n\n\n\n

MSSQL<\/strong><\/h2>\n\n\n\n

Na zobrazenie do do Windows 10 doin\u0161taloval SW priamo od Microsoftu (URL – SSMS<\/a>). <\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n

POZOR !!! Treba si pre spr\u00e1vnu identif\u00edkaciu v\u0161\u00edma\u0165 aj popis PC\/NB, nako\u013eko ESMC umo\u017e\u0148uje aj zaradenie jedn\u00e9ho PC\/NB viac kr\u00e1t.<\/strong><\/p><\/blockquote>\n\n\n\n

Z v\u00fdstupu vid\u00edme zoznam PC\/NB, ktor\u00e9 nemaj\u00fa pridelen\u00e9ho pou\u017e\u00edvate\u013ea z AD.TUKE.SK.<\/p>\n\n\n\n

  1. PC s n\u00e1zvom „pcwin10_205-008<\/strong>„<\/li>
  2. a NB s n\u00e1zvom „nb-p-m“<\/strong> , ktor\u00fd je tam DVA KR\u00c1T nako\u013eko sa pripojil mimo LAN TUKE. <\/li><\/ol>\n\n\n\n

    MySQL<\/strong><\/h2>\n\n\n\n

    Pre MySQL som povolil port 3306 a cez PHP skript som vytvoril dotaz na MySQl.<\/p>\n\n\n\n

    V\u00fdpis po\u010dtu naimportovan\u00fdch \u00fa\u010dtov z AD.TUKE.SK:<\/strong><\/em><\/p>\n\n\n\n

    https:\/\/cecetka.cp2.tuke.sk\/esmc\/script_c<\/a>1.php<\/a><\/p>\n\n\n\n

    V\u00fdpis zoznamu PC\/NB ,m ktor\u00e9 nemaj\u00fa pridelen\u00e9ho pou\u017e\u00edvate\u013ea z AD.TUKE.SK (script \u010d.3 je len vylep\u0161en\u00e1 verzia vo\u010di scriptu \u010d.2, zobraz\u00ed aj , kde je dan\u00fd PC\/NB zaraden\u00fd s tromovej \u0161trukt\u00fare):<\/em><\/strong><\/p>\n\n\n\n

    https:\/\/cecetka.cp2.tuke.sk\/esmc\/script_c2.php<\/a><\/p>\n\n\n\n

    https:\/\/cecetka.cp2.tuke.sk\/esmc\/script_c3.php<\/a><\/p>\n\n\n\n

    Obsah PHP skriptov:<\/p>\n\n\n\n

    skript_c1<\/a>Stiahnu\u0165<\/a><\/div>\n\n\n\n
    skript_c2<\/a>Stiahnu\u0165<\/a><\/div>\n\n\n\n
    skript_c3<\/a>Stiahnu\u0165<\/a><\/div>\n\n\n\n

    <\/p>\n\n\n\n

    D\u00e1 sa prist\u00fapi\u0165 na MySQL aj cez prostredie Webmin.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Sl\u00fa\u017eia na vytvorenie preh\u013eadov v ESMC, ako s\u00fa pridelen\u00e9 licencie, PC\/NB \u017eiadaj\u00face licenciu a r\u00f4znych in\u00fdch preh\u013eadov. Bohu\u017eia\u013e som zistil, \u017ee nie je mo\u017en\u00e9 vytvori\u0165 niektor\u00e9 preh\u013eady. Hlavne preh\u013ead PC , ktor\u00fdch zanikol pou\u017e\u00edvate\u013e a u\u017e nie je pridelen\u00fd dan\u00e9mu PC resp. NB. Na toto zistenie som vytvoril SQL dotaz, ktor\u00fd to vyp\u00ed\u0161e. SQL dotazy …
    \u010c\u00edta\u0165 \u010falej 6 Reporty<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"_links":{"self":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/771"}],"collection":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=771"}],"version-history":[{"count":22,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/771\/revisions"}],"predecessor-version":[{"id":831,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=\/wp\/v2\/posts\/771\/revisions\/831"}],"wp:attachment":[{"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=771"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=771"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/robert.cecetka.website.tuke.sk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=771"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}