Difference between revisions of "Active Directory/Software Packages"

From WolfTech
Jump to navigation Jump to search
m (Reverted edits by Dfsterli (Talk); changed back to last version by Abstein2)
 
(20 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
{{Active_Directory_toc}}
 
{{Active_Directory_toc}}
−
The WOLTECH domain was designed to ease, automate, and monitor the distribution of software to computers. We have an extensive list of software that has been packaged and configured for distribution via the domain, and new packages are being added every day.
+
The WOLFTECH domain was designed to ease, automate, and monitor the distribution of software to computers. We have an extensive list of software that has been packaged and configured for distribution via the domain, and new packages are being added every day.
  
 
==Available Packages==
 
==Available Packages==
−
The following software products are packaged and available for automatic distribution over the network. To request that software be installed on your computer, please email [mailto:ecehelp@ncsu.edu?Subject=Software%20Installation%20Request ecehelp@ncsu.edu].
+
The following software products are packaged and available for automatic distribution over the network. To request that software be installed on your computer, please contact your departmental IT Support. Once the software package has been assigned to your computer, you can simply reboot and the software will be installed during Windows bootup.
  
−
Once we have configured the software to install on your computer, you can simply reboot and the software will be installed during Windows bootup.
+
Please note that many software packages have additional license restrictions not listed in the table and that not all NCSU software has been packaged for distribution on the domain. If you don't see the software you need, be sure to contact your local IT support as they may be able to install that software manually for you.  
  
−
Notes:
+
Note:
−
 
+
* The date listed is the creation date of the package, not the release of the software.  
−
*Many software packages have additional license restrictions not listed in the table.
+
* Type can be "EX" for Experimental (untested) packages; "FW" for Freeware; or "SW" for Software or Licensed applications.
−
*Software packages that are only available for manual installation are not listed here.
+
* Scope refers to the level at which a package has been made available within in the NCSU hierarchy. Packages released at the NCSU level are available for assignment to all NC State computers (though licensing restrictions may apply). Packages released at a College level are available within that college and its departments. Software with the scope of a single department will only be available to computers within that department.
 +
* The data that feeds this report is updated every hour on the half-hour.
  
  
Line 16: Line 17:
 
//
 
//
 
define ('INCLUDES',"../_include/");
 
define ('INCLUDES',"../_include/");
−
require_once(INCLUDES . "myit/myit.inc.php");
+
require_once(INCLUDES . "myit/functions.inc.php");
 +
require_once(INCLUDES . "myit/phpAD-nodie.inc.php");
 +
 
 
$server  = $DB["server"];
 
$server  = $DB["server"];
 
$username = $DB["read-un"];
 
$username = $DB["read-un"];
 
$password = $DB["read-pw"];
 
$password = $DB["read-pw"];
 
$database = $DB["database"];
 
$database = $DB["database"];
−
$table = "packaged_software";
+
 
 +
$adServer = $WOLFTECH['server'];
 +
$adDomain = $WOLFTECH['domain'];
 +
$adUser = $WOLFTECH['myit.rd-un'];
 +
$adPass = $WOLFTECH['myit.rd-pw'];
 +
 
 +
$AD = new phpAD($WOLFTECH['server'], 3269);
 +
$AD->bind($WOLFTECH['myit.rd-un'], $WOLFTECH['myit.rd-pw']);
 +
 
 +
 
 
// Connect
 
// Connect
 
$link = mysql_connect($server, $username, $password)
 
$link = mysql_connect($server, $username, $password)
 
or die("Unable to connect to database server");
 
or die("Unable to connect to database server");
−
// Select Table
+
$i = 0;
−
@mysql_select_db($database)
+
$getSW = mysql_query("SELECT owner, sw_type, vendor, name, version, other, replication FROM wolftech_myit.log_sw_groups WHERE owner=replication AND sw_type<>'DN' ORDER BY vendor, name, version, other");
−
or die("Unable to select database");
+
if(!($getSW && mysql_num_rows($getSW))) {
 +
  echo "<strong>ERROR: Software data is currently unavailable</strong>";
 +
} else {
 +
echo '<table width="100%"><thead><th style="text-align: left; vertical-align: bottom">Name</th><th style="text-align: left; vertical-align: bottom">Version</th><th style="text-align: left; vertical-align: bottom">Date</th><th style="text-align: left; vertical-align: bottom">Type/Scope</th></tr></thead><tbody>';
 +
while ($a = mysql_fetch_row($getSW)){
 +
 
 +
if (empty($a[5])){
 +
$sw = $a[0] . '-' . $a[1] . '-' . $a[2] . '-' . $a[3] . '-' . $a[4];
 +
$findC = ldap_search($AD->_conn, 'DC=wolftech,DC=ad,DC=ncsu,DC=edu', '(CN=' . $AD->checkInput($sw) . ')', array('whencreated'));
 +
$tempOther = ldap_get_entries($AD->_conn, $findC);
 +
$a[5] = substr($tempOther[0]['whencreated'][0], 0, 4) . '-' . substr($tempOther[0]['whencreated'][0], 4, 2) . '-' . substr($tempOther[0]['whencreated'][0], 6, 2);
 +
} else if (preg_match('#^[0-9]{8}$#', $a[5])){
 +
$a[5] = preg_replace('#^([0-9]{4})([0-9]{2})([0-9]{2})$#', "$1-$2-$3", $a[5]);
 +
}
 +
 
 +
if ($lastVendor != $a[2])
 +
echo '<tr style="background-color: #ADD8E6;"><td colspan="4"><strong>', $a[2], '</strong></td></tr>';
 +
 
 +
echo '<tr style="background-color: ', ($i ^= 1) ? '#E7E7E7' : '#F8F8F8' ,'"><td>', $a[3], '</td><td>', $a[4], '</td><td>', $a[5], '</td><td>', $a[1], '/', $a[6], '</td></tr>';
  
−
echo "<HTML>\n<HEAD>\n\t<title>$title</title>\n</HEAD>\n<BODY>\n";
+
$lastVendor = $a[2];
−
$query = "SELECT vendor,title,version,licensor,notes FROM $table "
+
}
−
  . "ORDER BY vendor, title, version";
+
echo '</tbody></table>';
−
$result = mysql_query($query)
+
echo '<p><strong>Total Packages:</strong> ', mysql_num_rows($getSW), '</p>';
−
or die("Query failed! $result");
+
 
−
echo "<table BORDER=0 cellpadding='0' cellspacing='3'>\n";
+
mysql_free_result($getSW);
−
echo "\t<tr><th>Vendor</th><th>Title</th><th>Version</th><th>Licensor</th><th>Notes</th></tr>\n";
 
−
while ( $line = mysql_fetch_array($result, MYSQL_ASSOC) ) {
 
−
  if($count++ % 2 == 0) echo "\t<tr bgcolor=#E7E7E7>\n";
 
−
  else echo "\t<tr bgcolor=#F8F8F8>\n";
 
−
  foreach ($line as $col_value) {
 
−
      echo "\t\t<td>$col_value</td>\n";
 
−
  }
 
−
  echo "\t</tr>\n";
 
 
}
 
}
−
echo "</table>\n";
 
−
echo "</BODY>\n</HTML>";
 
−
// Free resultset
 
−
mysql_free_result($result);
 
 
</php>
 
</php>
 +
 +
For more information about the Software Packages that currently exist on the WolfTech Active Directory, OU admins can visit the "[http://www.wolftech.ncsu.edu/adtoolkit/wrap/software_tools Software]" section of AD Toolkit

Latest revision as of 15:21, 4 September 2015

The WOLFTECH domain was designed to ease, automate, and monitor the distribution of software to computers. We have an extensive list of software that has been packaged and configured for distribution via the domain, and new packages are being added every day.

Available Packages

The following software products are packaged and available for automatic distribution over the network. To request that software be installed on your computer, please contact your departmental IT Support. Once the software package has been assigned to your computer, you can simply reboot and the software will be installed during Windows bootup.

Please note that many software packages have additional license restrictions not listed in the table and that not all NCSU software has been packaged for distribution on the domain. If you don't see the software you need, be sure to contact your local IT support as they may be able to install that software manually for you.

Note:

  • The date listed is the creation date of the package, not the release of the software.
  • Type can be "EX" for Experimental (untested) packages; "FW" for Freeware; or "SW" for Software or Licensed applications.
  • Scope refers to the level at which a package has been made available within in the NCSU hierarchy. Packages released at the NCSU level are available for assignment to all NC State computers (though licensing restrictions may apply). Packages released at a College level are available within that college and its departments. Software with the scope of a single department will only be available to computers within that department.
  • The data that feeds this report is updated every hour on the half-hour.


<php> // define ('INCLUDES',"../_include/"); require_once(INCLUDES . "myit/functions.inc.php"); require_once(INCLUDES . "myit/phpAD-nodie.inc.php");

$server = $DB["server"]; $username = $DB["read-un"]; $password = $DB["read-pw"]; $database = $DB["database"];

$adServer = $WOLFTECH['server']; $adDomain = $WOLFTECH['domain']; $adUser = $WOLFTECH['myit.rd-un']; $adPass = $WOLFTECH['myit.rd-pw'];

$AD = new phpAD($WOLFTECH['server'], 3269); $AD->bind($WOLFTECH['myit.rd-un'], $WOLFTECH['myit.rd-pw']);


// Connect $link = mysql_connect($server, $username, $password) or die("Unable to connect to database server"); $i = 0; $getSW = mysql_query("SELECT owner, sw_type, vendor, name, version, other, replication FROM wolftech_myit.log_sw_groups WHERE owner=replication AND sw_type<>'DN' ORDER BY vendor, name, version, other"); if(!($getSW && mysql_num_rows($getSW))) { 

  echo "ERROR: Software data is currently unavailable";

} else {

echo '

<thead></thead><tbody>';

while ($a = mysql_fetch_row($getSW)){

if (empty($a[5])){ $sw = $a[0] . '-' . $a[1] . '-' . $a[2] . '-' . $a[3] . '-' . $a[4]; $findC = ldap_search($AD->_conn, 'DC=wolftech,DC=ad,DC=ncsu,DC=edu', '(CN=' . $AD->checkInput($sw) . ')', array('whencreated')); $tempOther = ldap_get_entries($AD->_conn, $findC); $a[5] = substr($tempOther[0]['whencreated'][0], 0, 4) . '-' . substr($tempOther[0]['whencreated'][0], 4, 2) . '-' . substr($tempOther[0]['whencreated'][0], 6, 2); } else if (preg_match('#^[0-9]{8}$#', $a[5])){ $a[5] = preg_replace('#^([0-9]{4})([0-9]{2})([0-9]{2})$#', "$1-$2-$3", $a[5]); }

if ($lastVendor != $a[2])

echo ''; echo '';

$lastVendor = $a[2]; }

echo '</tbody>
NameVersionDateType/Scope
', $a[2], '
', $a[3], '', $a[4], '', $a[5], '', $a[1], '/', $a[6], '

'; echo '

Total Packages: ', mysql_num_rows($getSW), '

';

mysql_free_result($getSW); } </php>

For more information about the Software Packages that currently exist on the WolfTech Active Directory, OU admins can visit the "Software" section of AD Toolkit

Retrieved from "https://tools.wolftech.ncsu.edu/support/index.php?title=Active_Directory/Software_Packages&oldid=10712"